Linking Tables Using AutoNumber Primary Key

[Hackney]

I have three tables.

EAch has a field called ID that is an Autonumber that is the primary key.

When I enter data via a form each record has a different ID across the three tables.

Does this mean they are not linking up correctly?

I have attached my databaset if that helps.

Thanks.

 

[Hackney]

Ignore this one please.