I have a table with a primary key with auto-enter Options: Serial number, On commit, increment by 1, and Prohibit modification. There are 2 very big problems I need help with finding fairly quickly;
- a serial number (1572) was repeated,
- the serial number generated is set in a Global field and use in a script to generate a unique field value in another table. The serial number is the foreign key in the second table an for some reason the values are not correct.