S
Simon Lang
I know this will all fall into place at some point. I have a "contacts" table
and form and a "contact notes" table and form. I want to place the "notes"
form as a sub form (datasheet) on the "contacts' form so people can make ad
hoc notes about the client etc. this table is just a date and text field. The
two tables have the auto id as the primary key. This relationship is one
(client) to many (clients notes)?. and is the auto id sufficient. I seem not
to be able to keep the data together or it doesn't save. I'd greatly
appreciate a simple walkthrough because quite frankly, I'm doing something
wrong and it's doing my head in, many thanks in advance
and form and a "contact notes" table and form. I want to place the "notes"
form as a sub form (datasheet) on the "contacts' form so people can make ad
hoc notes about the client etc. this table is just a date and text field. The
two tables have the auto id as the primary key. This relationship is one
(client) to many (clients notes)?. and is the auto id sufficient. I seem not
to be able to keep the data together or it doesn't save. I'd greatly
appreciate a simple walkthrough because quite frankly, I'm doing something
wrong and it's doing my head in, many thanks in advance