add 1 to last fileid (1 Viewer)

[GRM-kenyette]

hi all
i have a fileid that i dont want to make a autonumber, but i want to act like an autonumber ,take the last id and add one when you choose new record only on a form with a subform.
thanks in advance

 

[Birdy]

You will need to run a new query to find the MaxofID and then the next field will be a calculation of NewID:[MaxofID]+1

This is then brought into your form.