For simplicity sake I have 2 tables - they hava a one-to-one relationship. I have created a form for the second table and it is a subform on the first tables form. All OK so far.
I enter the primary key information in the main form and tab down to the sub form and enter a record of data - This works OK both tables get updated. However ACCESS allows the user to enter a second record in the subform - it correctly says at the commit stage that it cannot be added because of key integrity, but that is after all the data entry has been made to the second record - Is there any way of only allowing the user to enter one record.
Have tried setting add record to no but this prevents a new record being added to the second table when a new record is added to table one.
All help appreciated - I am aware of db normalisation but the long and short is that I need a one-to-one relationship as the number of field will exceed 255).