I’m new to Airtable, but have extensive experience in SQL databases. I could do something like the following in Access, but I want to make this database cloud native. Any assistance would be appreciated.
I’m working with a consulting firm that has ~50 consultants who relate to one or more legal affiliates of the firm through independent contractor agreements (ICA). Each ICA formally connects one of our legal affiliates with an “external entity” (an LLC, a sole proprietorship, etc.) to which a consultant belongs. Each consultant may have one or more external entities that they are themselves connected to.
I have built my base like this:
I want to be able to create a Consultant view (ideally a card/grid-view) that would show me the consultant’s information and a list of all the agreements that are related to him/her through the external entity table. However, I can only figure out how to display data that is from the directly related table “Consultant/Entity Relationships”.