Display one Field but store another
I have two tables. Jobs & States
Jobs has information about jobs worked on.
States has a fields (StateName, StateAbbreviation, TerritoryName, fkJobID)
On the layout where I am keeping jobs information I used property inspector to "display data from" and chose State:StateName.
There is a relationship from States to JobID where states can create records in jobs.
I want the user to drop down and see the names of the states spelled out but then store the state abbreviation in the jobs field.
I'm getting nothing in the jobs layout when click that field.