duplicate records and auto number

S

Swathi

Hi All,

1. I have a form that is used to add new records to the existing table
I have a field called N_NUMBER which has unique numbers for eac
existing record and it is not of type autonumber. Now, that I want t
add new record, I want the N_NUMBER field to display automatically th
next number((max(N_NUMBER)+1)) and so forth for each new record I add


2. Now that I am adding new records incase I want to duplicate th
record through the form, how can I duplicate the records with uniqu
N_NUMBER generation for each duplicate record.

Can someone please tell me how to do these step by step as I am new t
Access.

Please help me!!

Thank
 
Top