Form coding for 1-1 relationship

[mscertified]

I have a form that is bound to a table. This table has a 1-1 relationship
with another table. The data from this other table also appears on the form.
I need to retrieve this related data and update it or add a new record when a
new record in the bound table is added.
What is the best way to do this? Currently the form is bound to the main
table and the other data is all unbound and I have to handle all updates and
adds in code - which is proving quite complex.
Could I have this other data in a subform (even though it would have just
one record) and have it updated or added automatically? If I do this and make
a change to data in both the main form and the subform and then move to
another record, would both tables be updated automatically? Thanks.

 

[Klatuu]

I am not positive this option will work, but you might try using a query that
joins the two tables as the form's record source. It that will not work,
then form/subform would be the way to go.