Hi expert, I have a question. I have added an extra field in the item table and filled out the data. Then created a new report based on the table. When running the report, I could select the item no from the dropdown list of No filter, but not the new field I created and I had to enter the value. How to select the value from the list instead of entering the value? Thank you!
*This post is locked for comments
Thank you very much! This new filed will not fetched from the other table. So it doesn't work. After further testing, I realized it. Thank you all!
Hi,
Please do not get confused by the various replies.
Keep it simple.
What is the field that you have created at Item Table? If that field is only entry field, you would not get Lookup.
However, if the value in that particular field is being fetched from other table, you would get it lookup of that field.
For e.g. Please check the Base Unit of Measure field TableRelation Property. Data is getting fetched from other table and hence you would get the lookup of that field.
Hey Snoppy,
No Issue even if you created the field in the Item Table. Just give the lookup of the Item No it will work.
But I created the new field in the same table (Item table). How do I define the table relationship?
Do I really need to create a new table and move the data to the new table and then create the relationship with the Item table in order to do that? Thank you!
Hey Snoppy,
Just copy and paste the Table Relation Property of the No Field to the one you newly created. It will work for sure as you are expecting.
Have you defined any "Table Relation" Property for that newly created field?
Hi,
Did you try creating a new table and move the new field data in a <key, value> pair and in the Item Table, giving the TableRelation to the newly created table?
Hope it helps.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156