Setting NextSerialValue after import

[Mandu]

Is there any brilliantly simple way to set the next serial value for a field after importing a bunch of records from another FM table?

I can't figure out how to reach out and copy it from the source table. I tried to write a sub-script to accept table name and field name, and then sort/take highest value/serial increment/set next serial value, until I again discovered that Sort can't take parameters .

Short of brute force, is there a better way to accomplish this?

Thanks,

Chap

[Ocean West]

you could sort the table by serial number go to last record set a variable to that ID number one then use the script

Set Next Serial Number [ IDFIELD ; $$value + 1]

[mr_vodka]

You can set a variable with the Max () function of the table occurrence. You can use a cartesian join to get a max of the entire table.