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" ...
Forum Discussion
You have
Contacts < Writer Outlets > Outlets < Outreaches
I think what you want is this
Contacts < Writer Outlets > Outlets < Outreaches > Writer Outlets
So create a new Relationship where One Writer Outlet has many Outreaches.
Then on the Outreach relationship field called [Related Writer Outlet], set the field properties for that field to be "Conditional". so that after selecting [Related Outlet]
only show choices where that field equals [Related Outlet] of the Writer Outlet records.
... that should work, post back if you get stuck.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Contacts < Writer Outlets > Outlets < Outreaches
I think what you want is this
Contacts < Writer Outlets > Outlets < Outreaches > Writer Outlets
So create a new Relationship where One Writer Outlet has many Outreaches.
Then on the Outreach relationship field called [Related Writer Outlet], set the field properties for that field to be "Conditional". so that after selecting [Related Outlet]
only show choices where that field equals [Related Outlet] of the Writer Outlet records.
... that should work, post back if you get stuck.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Thanks, Mark. When I create the Writer Outlet < Outreach Relationship, I only have the options to add [Related Outlet] and [Related Contact]. I don't see [Related Writer Outlet] as a Field option.
------------------------------
Chelsea Giacchi
------------------------------
------------------------------
Chelsea Giacchi
------------------------------
- If you like contact me by email and I will hop on a quick zoom call with you.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
