For example, I have the following parent child relationship:
Using the above data model, I would like to populate a custom drop down menu within a 'child' form with *select* values that exist in the parent table.
For example, I envision populating my drop down menu with values that come from the following query:
SELECT Parent_Record.Customfield2 FROM Parent_Table WHERE Parent_Record.Customfield1 = 'Hello'
Running the above query will add the following selectable values into my custom drop down menu (present within a child form) :