I am working on an ms Access database, where I have 5 tables (Technicians, non-Technicians, user-passes, times, and faults). The technician and non-technician tables are reated to user-passes table. In both technician and non-technician tables I made a field with autonumber data type, and they are linked to a field (I called employee number) in the user-pass table with a long integer number data type that I fill up manually through a form.

The problem is that, I tested a form with "employee number" field but when I check either thrtechnician table or thr non-technician table I get a different number. In fact, the numbers I see in the tebles are in order which means that as if the fields are auto numbering

can anyone help? why is this happeing? how can I fix it?

Thanx guys