This content has been marked as final. Show 2 replies
If I understand correctly, you want the user to select the Company Name, but you only want to save the Company ID? First thing that comes to mind is to setup the value list to use the Company ID as the primary value, the Company Name as the secondary, and only display the secondary value. Use this value list on the Company ID field in Table X; The user can select the company name, but afterwards, the ID is what is shown/stored.
Yes correct. And be sure that you use a pop-up value list and not a drop-down ... drop-downs don't allow inserting the ID and displaying the name like pop-ups do. Also drop-downs can allow a User to type something incorrect into the ID field (free text) whereas pop-ups naturally restrict to valid IDs.