ChelseaGiacchi
4 years agoQrew Member
Filtering drop down options
I have three tables that are related in the following way:
Contacts
Outlets
Writer Outlets
"Contacts" is a Parent Table to "Writer Outlets"
"Outlets" is a Parent Table to "Writer Outlets"
The "Writer Outlets" table was created to connect/associate Contacts and Outlets. This table works how it's supposed to. If you go into a Contacts record, you can see all associated Outlets and vice versa.
There is a fourth table, "Outreach", where I'm trying to create a form to keep track of outreach for specific Outlets. Because an Outlet may have multiple Contacts associated with it, I'd like to be able to select the Outlet and then have the list of Contacts filter based on the Outlet selected so that our team can record the Outlet that was contacted and the individual person that was contacted at the Outlet.
I need assistance with creating the relationships for the Outreach table.
------------------------------
Chelsea Giacchi
------------------------------
Contacts
Outlets
Writer Outlets
"Contacts" is a Parent Table to "Writer Outlets"
"Outlets" is a Parent Table to "Writer Outlets"
The "Writer Outlets" table was created to connect/associate Contacts and Outlets. This table works how it's supposed to. If you go into a Contacts record, you can see all associated Outlets and vice versa.
There is a fourth table, "Outreach", where I'm trying to create a form to keep track of outreach for specific Outlets. Because an Outlet may have multiple Contacts associated with it, I'd like to be able to select the Outlet and then have the list of Contacts filter based on the Outlet selected so that our team can record the Outlet that was contacted and the individual person that was contacted at the Outlet.
I need assistance with creating the relationships for the Outreach table.
------------------------------
Chelsea Giacchi
------------------------------