Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Filter information based on linked table

Topic Labels: Base design
237 0
Showing results for 
Search instead for 
Did you mean: 

I am an Airtable newbie but familiar with database design in general. I am struggling with a relatively simple design that would be relatively easy in SQL design.

I am building a relatively basic CRM system. Accounts, Contacts, Opportunities (there are other tables but that isn’t relevant).

Obviously, multiple Contacts are associated with one Account. Multiple Opportunities are associated with one Account. Each Opportunity has only one Contact owner and that Contact works for that Account.

Create New Opportunity. Link the Account and the list of Accounts comes up - select one of them. Add Opportunity Owner by hitting the plus symbol and every Contact in Contacts is presented, not just the Contacts associated with the Account.

I am surely doing something incorrectly. How do I get the second Linked field to be filtered by the first Linked field?

Thank you for helping a newbie out.

0 Replies 0