Problem with synching two tables
I am absolutely frustrated at the moment. I would kindly appreciate any help possible!
I have a problem trying to give a certain input that automatically creates a new record. There are 2 Tables. One is displaying the projects, whilst the other ones is displaying my contacts. The project table contains the contacts.
What I'm trying to do is to create the project in the project table and to input the contact information into this "project record". This should automatically lead to a new contact record in the "contact table" being created.
Step two would have a 'related projects' field in the new contact record displaying the project whose new contact information just spawned that record.
I tried to roughely visualize this here:
Basically, a new record in one table leads to a new record being created in the other table.
Thank you in advance for any help!