second autonumber field

[dolfan1873]

i know you can't have two autonumber fields in access, but can i make a number field that will act like an autonumber, when i add new records i need this second field to go up by one number also, i tried using the max()+1 in the default value but that didn't work.

 

[lupins46]

Sorry to be so blunt, but there can be no reason on earth that a table would have two fields with the same value.

 

[hymn]

I haven't the foggiest why you want it but

MembershipNo = DMax("[MembershipNo]", "tblperson") + 1

Dont forget to change the names to suit you


Hope this helps
Hymn

 

[dolfan1873]

i have joined 2 tables that had autonumber fields and for tracking purposes i need to keep both number fields, they are not the same and i just wanted to make it update itself rather than me inputing the number.

thanks