Hi,
I have successfully created a new field for an existing table using the lookup type. However, the field that it brings back is a code and I want it to show the description of the lookup value. Is it possible to change the value the lookup brings back.
This is within the dimension tables
Thank you
Regards
hougaard Answered question January 17, 2025
A “lookup” field will always retrieve the primary key from the record you select, that’s how a lookup field works.
If you want the description pulled over also, then you can add an extra field and have the description field transferred as a lookup field transfer. (Example, you lookup an item number and also transfer the description).
hougaard Posted new comment January 20, 2025
Do you have a filter on the dimension code field?
Thank you for the response.
I think the next issue is coming about because it is all within the Dimension Value table. The error message I am receiving when trying to add content into the fields is
“The field Manager_Name of table Dimension Value contains a value (NAME) that cannot be found in the related table (Dimension Value).”
Even though it is within that table number