Display single parent field value based on parent dropdown on child form

Question

I have a table, for example, of states with two fields, the two letter state abbreviation and the spelled out name of the state. This table is the parent table.

I have a child table where I would like to have a drop down that displays the state abbreviation and after the user selects the desired state, the full state name is displayed on the form.

I don't mind storing the state abbreviation in the child table, just want to avoid storing the full state name.

I keep think I should be able to do this but drawing a blank on the secret sauce to make this happen.

TIA

------------------------------
Katherine Oakey
------------------------------

MichaelTamoush · Answer

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
------------------------------

Sign up

Login to the community