I have a table called 'users', each row has a unique ID (autonumber) -- userid
I have another table which is called 'firm', and a field (int) called: contactnumberstart
I need to update firm.contactnumberstart and make it = to the latest (or highest) userid + 1
This way I know which is the next ID.
I only need to update it once, the system will take care of updating that number whenever a new user id added.
It should be something like:
set contactnumberstart = MAX(users.userid) + 1
Well, that is the idea.