Newy - Stuck with syncronizing tables - please help

[honeyshape]

I've only been using access for a few weeks now. I'm stuck on something that is probably quite simple.

I have a table that has the following fields:
OperativeIDCode
FirstName
LastName

Then I have tables for, Address, Tax Info, Traning. etc.

I know that all the details could be put in one big table because each record is unique and only ever related to the same OperativeIDCode, but can i do it this way.

I have built a form with the other tables on subforms but I cant get the subforms to sync. I have put a link to the file below.

I have linked OperativeIDCode in each table back to the first table. I think I need access to automatically put the OperativeIDCode from the main table to the other table - my guess is that this is done thur forms and child and master stuff?

files.me.com/honeyshape/xe9vch

Can anyone help?

 

[RuralGuy]

It sounds like it may all go in one table but if you want to use separate 1:1 relationship tables then you need to put the PrimaryKey of the main table in the other tables as a ForeignKey. A query with joins will bring everything back together. Depending on the arrangement of your forms, the ForeignKey bay be a manual process on your part. 1:1 relationships are not automated by Access unless you use a MainForm/SubForm arrangement.