Multiple Nested Reference Tables and Automation

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:
job_base

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.