C
CW
I'm setting up a database of corporate customers, which will include our
contact persons at each of them. In some cases there are several contacts at
a company, with different roles.
I will create one table for the Companies and another for the Contacts and
then a subform for displaying these at the bottom of the main company form.
Presumably this is a classic one-to-many relationship and I will need a
primary key in the tblCompanies table (e.g. Company1) and then a similar
entry in the tblContacts table, for the link to be made.
Question - how does the key get entered into tblContacts? If there is a
relationship between the fields, will the relevant value (such as Company1)
be automatically passed into tblContacts when a new Contact record is
created, because that is how the main form and subform are linked ? Or does
the user have to input it manually?
Thanks
CW
contact persons at each of them. In some cases there are several contacts at
a company, with different roles.
I will create one table for the Companies and another for the Contacts and
then a subform for displaying these at the bottom of the main company form.
Presumably this is a classic one-to-many relationship and I will need a
primary key in the tblCompanies table (e.g. Company1) and then a similar
entry in the tblContacts table, for the link to be made.
Question - how does the key get entered into tblContacts? If there is a
relationship between the fields, will the relevant value (such as Company1)
be automatically passed into tblContacts when a new Contact record is
created, because that is how the main form and subform are linked ? Or does
the user have to input it manually?
Thanks
CW