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).
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
Do you have a filter on the dimension code field?