Drop down subject to a previous drop down
I have a COMPANY table CONTACTS table In the CONTACTS form there is a selection drop down for COMPANY this contact is associated with. PILOT PROJECTS table This form also has a select...
Forum Discussion
There is not a way to filter a multi select field type.
It is possible, however, to have a many to many relationship where
One Company has many Contacts
One Company has many Pilot projects
One Contact has Many Pilot Project Contact Assignments
One Pilot Project has Many Pilot Project Contact Assignments
The Pilot Project Contact Assignments table is the "join" table for the
many to many relationship. That drop down of Contacts can be filtered for just the Contacts for that company.
It is possible, however, to have a many to many relationship where
One Company has many Contacts
One Company has many Pilot projects
One Contact has Many Pilot Project Contact Assignments
One Pilot Project has Many Pilot Project Contact Assignments
The Pilot Project Contact Assignments table is the "join" table for the
many to many relationship. That drop down of Contacts can be filtered for just the Contacts for that company.