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.
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.
