Hi,
I have three tables that have a relationship one-one (using MSAccess). However, in VB2005 when I add a record in the first table the other tables does not generate a record as it do when the relationship is one-many. I'm not using datagrids. I'm using table1 in top of a form and the table2/table3 are in the same form as table1 but in tabs control.
Should i do some coding to manually relate table1 with the others....I'm really lost with this one-one relationship using Access and VB2005.

I have setup the database like this sample:

Table1:
table1ID - PK - Autonumber
Names - Text
LastName - Text

Table2:
table2ID - PK - Autonumber
table1ID - LongInteger and related one-one with table1(table1ID), Also Yes/No Duplicates.
Address - Text
State - Text

Thanks,
2005