mismatch in Key IDs

[accrep18]

I'm not sure how I got into this situation, but...



I have 4 tables and all share the Key ID.
It's been working well.
I recently was adding new records to each table when I saw
3 of my 4 tables are autonumbering correctly (creating new record), but the last one has jumped (instead of the next number being 4, it creates record # 12 for example)..

How to fix this ?!

[kd2017]

All four tables have a field named "Key ID" that are of AutoNumber datatype? And you're using this field to join the tables?

The correct way to go about this would be to use Primary key/ foreign key pairs. You link a table's primary key field (autonumber) to another table's foreign key field (number), you would define the relationship between the tables using the relationship window and set enforce referential integrity.

[orange]

This may help with autonumbers.

[accrep18]

OK, I see..

I just redid the relationships, so that the first table contains the only primary key and it connects to the foreign keys of each of the other 3 tables. And the foreign keys were switched to number (rather than autonumber).

But I still have the problem of being out of sync on the last table... How to re-sequence ?

[kd2017]

Can we see a screenshot of your data and your relationship window?

[CJ_London]

How to re-sequence

how many records? if only a few, do it manually. Or delete the lot and start again.

[accrep18]

After redoing the relationships per kd2017's advice, it now works. Thank you !