Guest_imported
New member
- Jan 1, 1970
- 0
Hi all,
i have a table call "customer orders" and in this table, there is a field that should be auto-assigned number and i want to use VB code to do (it's not autoID, because i only need this field some time, not everytime, and i already have autoID for the primary key).
I guess i have to first check throught all the record for the largest existing number, and then plus by 1 and assign it as the next number. how do i do that?
Cheers
Sam
i have a table call "customer orders" and in this table, there is a field that should be auto-assigned number and i want to use VB code to do (it's not autoID, because i only need this field some time, not everytime, and i already have autoID for the primary key).
I guess i have to first check throught all the record for the largest existing number, and then plus by 1 and assign it as the next number. how do i do that?
Cheers
Sam
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
