Show Last Used Number

[Lesg]

Hi Guys, We have made changes to a clients table and have added a new column 'codes22' which is because client wants to change his product numbering which was originally based on the tables PK 'productID' auto number.

The new column is set to be unique but allows nulls as they have 2 code ranges they want to manage items between 20000 to 29999 then 90000 to 99999

There is a form to edit existing or add new products but as field codes22 is no auto number, they need to add new number manually, so I am looking to see how I can add embedded forms showing the last 20000 number and the last 90000 number used, so they can add the next available number in the relevant sequence?



Thanks in advance

[Welshgasman]

Use DMax()

[xps35]

Why do users have to add the new number manually? I assume which series applies is inferred from other data. The process should therefore be automatable.