Effective links between tables

[E-D]

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 PeopleId field to be updated in frmAddress automatically
I used this code:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 however it didn't work for me.
How can I fix it?

 

[E-D]

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 ?

 

[E-D]

Thank you my friend
problem is solved !