Hi all,

I am using linked files back to access as a front end and hence want to be able to generate an autonumber that can be auto inserted into a field back in the linked database. Can I do this at form level, ie. as a default value on the ID field, and if so how? Due to the linked file being in DB2 I can't generate this number automaticly in the file definiation.

Is there a funtion that I can look at the last record in a table and add one etc, only if it is a new record?

Any help is greatly appreciated.