Hello helpful community! So here’s the deal:
We’re a small Venture Investment syndicate.
Among other things, we’re using AirTable to track investments into companies by our members.
Usually it’s pretty easy:
John Doe is a Member record in our Members table.
Company X is a Company record in our Companies Table.
The “2019 Series A Investment into Company X” is a Deal record in our Deals table (with Company X being pulled in from the Companies table of course).
For each investor (from our Members table) who chooses to invest in a Deal we create a new record in the Investments table. It’s the intersection of a Member with a Deal… with some additional info added, such as the amount they invested, the date the funds arrived, the wire transfer info, etc.
With me so far? Great. So here’s the problem. Not ever investment is made by a person. Some investments are made by legal entities like Trusts or LLCs. Of course those legal entities have points of contact like a name, phone number and email address. And to make matters worse, some points of contact manage more than one legal entity. So we might have investments made by John Doe, John Doe’s Living Trust, and John Doe LLC… which are really all the same person.
I can create an Legal Entity table where each entity has a record and all the associated contact info is listed, but then in my Investments table I would have some investments being made by a Member and some by a Legal Entity and I don’t know how to pull info from 1 of 2 different tables.
The only solution I’ve come up with is to create a record in the Legal Entity table for every single regular member, even though it’s just a duplicate of a lot of their info in the Members table. And then I’d pull info into the Investments table from the Legal Entity table, not the Member table.
This seems like a lot of duplicate data when only about 5% of our investments are made by these annoying non-people.