We’ve created an address book of sorts, and I could use your help in creating a dynamic single-select field. Here’s the scenario:
We have two tables: (1) tbl_organizations and (2) tbl_individuals. Any given organization may (and often does) have multiple individuals linked to it. However, we’d also like to designate one of these individuals as the primary contact for the organization.
Here’s it written out as an example:
Depp Organization is a record in tbl_organizations. It is linked to 3 records in tbl_individuals (Bob, Sue, and Timmy).
Foo Organization is a record in tbl_organizations. It is linked to 2 records in tbl_individuals (Sally and John).
I would like a create a field in the tbl_organizations. This field will be called something like “PrimaryIndividual.”
PrimaryIndividual will populate with the individuals linked to their organization record (but no other individuals).
As an example, for Depp Organization, the options will be Bob, Sue, and Timmy whereas for Foo Organization the options will be Sally and John.
Is something like this possible? Do folks have other creative solutions for getting similar results?