February 7, 200322 yr As I was testing my newly settled Serial Number (1-1,1-2,1-3,1-,4, using the classic method selfjoin and lookup to nextserial), I encountered some difficulties when importing. The serial was OK for a while, then started to count only the next serial number giving me 1-1,1-2,1-3,1-598.... My first thought was that the look-up couldn't be executed during the Import session. But after testing the same procedure on a reduced found set (1,000 records instead of 10,000), it worked. I ended up with a loop "create new records" based on a OnetoOne relationships and it worked fine, but I'm still wondering why it didn't work. Here is how my serial number is defined Serial N
Create an account or sign in to comment