AnsweredAssumed Answered

Display one Field but store another

Question asked by bokenrosie on Mar 13, 2014
Latest reply on Mar 14, 2014 by philmodjunk


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.

     Any thoughts?