ID Change With Auto Entry
I have an issue with auto entry being lost when I change the ID field in one of the tables. I have 2 tables and both are related through an ID field. The second table has some auto entry fields by calculation that pull information from the first table. If I change the ID for one of the records in the first table, I loose the auto entry fields for that record in the second table. The fields return if I manual change the ID in the second table to match the first.
Is there a way to establish auto entry for the ID field in the second table? When I try to do this by calculation, the database file locks up.