Forum Discussion

KatherineOakey's avatar
KatherineOakey
Qrew Member
4 years ago

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

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
------------------------------
Relationships
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    4 years ago
    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
    ------------------------------
    • KatherineOakey's avatar
      KatherineOakey
      Qrew Member
      4 years ago
      Insert 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
      ------------------------------