Multiple Nested Reference Tables and Automation

Topic Labels: Base design
648 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Greetings, I have a base for job hunting that I would like to share with others, but it currently requires too much manual entry to be widely practical. The structure of the base is:

Company -> Positions <-> Contacts <-> Activity

Every table is optionally linked to all the other tables.

The problem is that, let’s say I’m looking at a Contact, and I want to indicate that I spoke to someone on the phone – in the Activity record I may need to link to up to two additional tables manually (Company, and Position) even though the Contact record is already linked to a particular Company and Position.

Is there a way to automate filling in these record links so that the base is easier for folks to use?

Here is the ERD of the base for those so inclined:

0 Replies 0