how to auto inset sequence number at column

[newaccess]

Hi Experts,

I have linktable from oracle. right now, We manual insert sequence number into column when input data. do we have any way (create form, or VBA program) to auto insert sequence number at column?



how to auto inset sequence number at column in linktable?

I am using 2007 access in window XP.

Thanks for any help or example!
newaccess

[ssanfu]

Am I right in thinking that you have an Oracle back end that you are updating using an Access front end??

Would you elaborate more about what you are doing? Does the sequence number have any meaning?

There are lots of auto increment examples available. It all depends on your needs.