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:
