one form, two tables

[MarkRind]

I have created a form that inputs data into two tables. They are connected in a one to one relationship with both primary keys. Unfortunatly evertime I enter info on the form, the minute I enter info on the form for the child table, my data disapears at the beginning of the form. How can I stop that?

 

[wizcow]

Something you could try is make a query using the two tables, then relate the form to that query.

Tom