For some reason, various tables between records are adding connections between them on the database. The database is used to sort information from medical records. In the database, I have a portal table for medications, connected with auto-serial numbers. For some reason, random records (ex. #4 and #385) will automatically take the same serial number instead of its own unique value. This causes the tables to be connected and inserting information into one table changes information in the other record's table. Does anyone know why this is happening? Is there an issue with my database as a whole? How can I fix this?

Thank you very much!

-Mary

Are you using the FM auto-enter serial number feature on those fields? If so, can you verify that a plausible "next number" is listed when you look at the field in the "define database" dialog?

I have it so that it's currently set on "Serial Number, Generate: On creation, next value -- increment by 1".