Hey, I am looking for a way out have article number which must have to be
1) Unique
2) Sequential
3) other than ID field (Autonumber), if sequence is missing, then missing number can not be reused.
3) this can be 4-5 digits, can includes alphabets as prefix.
Environment is multiuser with having their own front end that's why it is very tricky. DMAX wont work in that case. For example if 5 users at the same time are data entering.
My Idea, How can this be possible, (May be you can give me different suggestion):
1) It might not have control on form
2) directly inside query which is linked with form to enter data in table.
3) Query keeps refreshing refreshing records from table, to know which is the last article number.
4) If someone saves records from form, query the inserts sequential number --- this way even if multiple users are entering data, Query will take care of it every second. and enter new sequential number.
How is it possible???
I have an other ways of unique article entery system but thats not unique , still want to share, may be for someone it is of interest. Article number is entered on YearMonthDayhrMinSecond (for example: 20210925125609) , It will always be unique (more than 99.95% chances)
Thanks in advance.
1) Unique
2) Sequential
3) other than ID field (Autonumber), if sequence is missing, then missing number can not be reused.
3) this can be 4-5 digits, can includes alphabets as prefix.
Environment is multiuser with having their own front end that's why it is very tricky. DMAX wont work in that case. For example if 5 users at the same time are data entering.
My Idea, How can this be possible, (May be you can give me different suggestion):
1) It might not have control on form
2) directly inside query which is linked with form to enter data in table.
3) Query keeps refreshing refreshing records from table, to know which is the last article number.
4) If someone saves records from form, query the inserts sequential number --- this way even if multiple users are entering data, Query will take care of it every second. and enter new sequential number.
How is it possible???
I have an other ways of unique article entery system but thats not unique , still want to share, may be for someone it is of interest. Article number is entered on YearMonthDayhrMinSecond (for example: 20210925125609) , It will always be unique (more than 99.95% chances)
Thanks in advance.