thank you for your kind answer, however
the tables I mentioned were only example for
better explaining my problem.
The real tables I wanted to relate are:
tblCostumers and tblOrders.
that's why I kept them apart.
Do you know how can I enforce such a relation ?
Happy new year !
I have two different forms:
frmPeople linked to Table TblPeople
and frmAddress linked to table tblAddress
both tables have PeopleID as a primary key field
I want to use a Command button in form frmPeople in order to go from frmPeople to frmAddress, but I also want
the...