|
AutoInc |
|
|
Click in the "Auto Increment" box to define this column as having to be automatically filled in with a NUMERICAL value incrementing at each record imported and starting (first imported record) with the "Auto Inc 1st Numb." value
In this case the autoinc will start at 12 and the second record will have a value of 13 etc ....
We have a check in code to retrieve the LAST DESTINATION record value and to add 1 to this value so as to avoid any DUPLICATE errors ( ie. : 101 records but "holes" in the count and last record value being say 103 - then the value displayed will be 104)
This option is VERY useful when you want to import records in an already filled in Table to add new records at the end |