Page 1 of 1

ongoing AutoNumber from different forms

Unread postPosted: Thu Jun 10, 2021 4:26 pm
by oli
Dear All,

I'm using an AutoNumber field to create ongoing numbers for records in table "contact".
Now I need to use 3 different forms for adding new contacts and I recognized that the numbers are not ongoing anymore.
Is there a simple way to use AutoNumber fields and avoiding the creation of records with the same AutoNr indipendent of the form?

Thanks in advance.

BR,
Oli

Re: ongoing AutoNumber from different forms

Unread postPosted: Thu Jun 10, 2021 6:52 pm
by kev1n
You can't use a nuAutoNumber in this case. You would probably have to create a separate table in which a consecutive number is incremented.

Re: ongoing AutoNumber from different forms

Unread postPosted: Fri Jun 11, 2021 1:56 am
by oli
Thank you!