Lookup behaviour during Importing

[Ugo DI LUCA]

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