Synchronising fields between 2 tables

[blueboy2001]

I am building a contacts database - brief structure as below:

tblOrganisation - details pertaining to the company

tblContact - Primary key is ContactID (autonumber) and details about the contact

tblContactDetails - Primary Key is DetailsID (Autonumber), Foreign Key of ContactID and fields to store various sets of details.

What I want to do is each time a contact is added I want to create an entry in tblContactDetails with their ContactID as the foreign key. I have created a form based on tblOrganisation, with a subform in Datasheet view showing the contact info (Name etc) which gives the + symbol to access the contact details. Trouble is if there is not an already entry in tblContactDetails with the same ContactID then there is no way I can add details.

 

[Pat Hartman]

Adding a row to the many-side table is not required at this time. If you cannot add the row to the subdatasheet, there is something wrong with your relationship. Fix the problem rather than applying a bandage.