Forum Discussion
MichaelTamoush
5 years agoQrew Captain
I'm not sure what you mean by "I don't mind storing the state abbreviation in the child table, just want to avoid storing the full state name", but your main ask can be done per a typical parent child relationship.
Create the relationship making sure your two letter state code is the proxy field (this is done by default if you select the 2 letter state code as your first lookup field when creating the relationship. Otherwise, the proxy field can be set from the field properties of the Related Field on the child table).
Then, select the full state name as a second lookup field, and display it on your form.
------------------------------
Mike Tamoush
------------------------------
Create the relationship making sure your two letter state code is the proxy field (this is done by default if you select the 2 letter state code as your first lookup field when creating the relationship. Otherwise, the proxy field can be set from the field properties of the Related Field on the child table).
Then, select the full state name as a second lookup field, and display it on your form.
------------------------------
Mike Tamoush
------------------------------
- KatherineOakey4 years agoQrew MemberInsert the appropriate blush here.
I thought I was doing it right and yes, I had set the 'abbreviation' field to the reference proxy and the full name as the second lookup field in the relationship.
It would help if I was displaying the lookup fields on the child form and not some other field...
It is now working as desired :)
------------------------------
Katherine Oakey
------------------------------