Hello -- We'd like to customize the items in a combo box in a form, so that users will choose from meaningful text labels which would be mapped to the actual values that are recorded in the database. For example, there might a Lab table with 3 rows:
id, name
1, Darwin
2, Einstein
3, Curie
An Experiment table would have a 'lab' field which references 'id' in the Lab table. There will be a form for entering data into the Experiment table. We'd like users to see the items from Lab 'name' in a combo box ('Darwin', 'Einstein', and 'Curie'), but based on their choice, either '1', '2', or '3' would be recorded in the Experiment 'lab' field. Is it possible to set it up this way?
Thanks!