I am working on an employee booking database and am having an issue with one particular component. I am setting up an add customer form (see the enclosed JPG file). As you will see, the customer form has within it a sites subform (each customer could have multiple site addresses). You will also see that the sites subform has within it a contacts subform because each site can have multiple contacts.
Now, when I bring up the form, it is displaying the information as I have entered it through the datasheet view - that is fine. But when I try and enter in new contact information in the subform, it is not working.
My data structure is that the customers table is linked to the sites table through "site ID"; the sites table is linked to a sitecontacts table through "site ID"; and the sitecontact table is linked to the contacts table through "contact ID". I wasn't having any luck in linking the sites table and the contacts table directly to ensure I could get multiple contacts for a site (unless I was doing something wrong).
Now it seems that the problem is in this sitecontact table (which consists of 3 fields, sitecontactID, siteID and contactID. sitecontactID is an autonumber field as is the contactID in the contacts table. My form is trying provide an autonumber for both. But it would seem a must to do so as both must be updated - the sitecontact table provides the relationship between the site and the contact while the contacts table provides the contacts info.