max serial_number

[asarak]

Hello friends,

i ve got a problem, i have a table named "tbl_main_data" having a field sn which is long int, and unique indexed.

in a form named frm_main_data i have this field in order to entry my new sn in any new record.
i want to have a text that displays the maximum+1 of this sn number in order to avoid the duplicate sn input. My client have this like that, and not as a autonumbered....

So if you have a tip in how to get the max number and put it in an "field.text".

thanks a lot

Regards

ASARAK

 

[neileg]

Use DMax(). Generating your own sequential numbers is often covered in here. Do a search.

 

[asarak]

excellent

it works fine.... so simple...

asarak



thanks a lot Neileg

greeting from sunny Athens Greece