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

2 Responses

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

Leave a Reply