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
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).
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