import record and auto enter serial numbers

[The Big Bear]

Hi all

I import records into a file with an auto enter serial number. Import does not trigger the auto enter function as far as I can see.

I tried creating a summary field to capture the max serial number and wrote a looping script and used the set field command to set the empty serial numbers.

Goto first record

loop

if(isempty(serialnumber)

set field (sumary field; serial number)

else

goto next field (exit after last)

endif

end loop

this works but this goes through all the records every time we would import records and soon are later this will get slow.

I tried using the Max function, Max(serialnumber) and designated it as a global field and find all records with a blank serial number but Max(serialnumber)as a global field is empty.

I know there is a better way of updating auto enter serial after importing records but that is beyond me and I would appeciated your help.

I also did a search of the forums and caming up empty.

Thanks

Lionel

Thanks

[LaRetta]

Hi Lionel,

The auto-enter serial will fire during an import if you check the 'perform auto-enter' option within the dialog which appears after you've selected to import and immediately before the import runs. And make sure the serial field has an auto-enter calculation (check in field definitions, Options tab under auto-enter).

[The Big Bear]

LaRetta

Thanks for the information

Lionel