Hi all,

I have just began studying access and am having a problem with a particular form. The form is based on two tables and the data populating this form comes from a query of the two tables. Although I can change data in the underlying tables with this form, I cannot ADD NEW RECORDS with it!! The error message is as follows:
"The current field must match the join key 'Customers.Customer Number' in the table that serves as the 'one' side in the one-to-many relationship. Enter a record in the 'one' side table with the desired key value and then make the entry with the desired join key in the 'many-only' table".
It appears to be telling me to add the data in the underlying tables!
Any help would be greatly appreciated.
Thanks guys

Don't use a 1 to many relationship for a form.
Say, for example you have Customers and Orders, where one customer can have many orders:
Have Customers as the main form, and Orders as a subform.

Steven

I am a loud man with a very large hat. This means I am in charge