Reading ID Numbers from a 2 Column Value List
This is probably a dumb question, but here goes:
I've got a two column value list displaying as a pop up menu. One column is an ID number (hidden) and the other is the record's name (displayed). Then I have a field set up to read the ID number from the pop up menu. The calculation is simply "Job:EmpID=Job::EmpSelect" where EmpSelect is the pop up menu. This successfully displays only the ID number when I manually create a record from that layout. However, when I go to a portal in another layout and try to create a record in the Job table, (after using the EmpSelect pop up menu in the portal) I go back to the Job table and EmpID is displaying as the text name found in the value list. If I reselect the value in the Job layout, everything is fixed. But my question is: is there something I should be doing to make sure it always reads only the ID number on the first try?