AnsweredAssumed Answered

auto-Enter Options

Question asked by rtolliver on Aug 14, 2015
Latest reply on Aug 17, 2015 by rtolliver


auto-Enter Options


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.