How do I create a link-to-parent lookup field?
I think that's the right term for it. I want to create a field in a child table that is linked to the parent table. For example, I want the contacts table to have an "Organization" field, and that organization name should be linked and pulled from the "Company" table.
John McGarvey commented
If you have Administrator rights to your application, you can create the link-to-parent lookup (if the two tables are already created) by going to the Table Relationships within Admin Menu.
1. Find the parent table (Company) in the list and and click "Add A New Relationship".
2. The parent table will be pre-populated. Select the child-table (Contacts) in the 2nd field.
3. Change the Relationship Name to "Organization".
This will create a parent-child (1-to-Many) relationship.