AnsweredAssumed Answered

ID Change With Auto Entry

Question asked by Fred_3 on May 10, 2015
Latest reply on May 11, 2015 by philmodjunk


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.