I have a list of numbers, they are used for unique product codes.
As you can see the last number we used was 201028.
When a user enters a product in another module, it looks up the BVFSKUID from this list using the BVFSKU column, If there is no matching record, we need to create a new line in this list, with the BVFSKU Description they have, and a new BVFSKUID using the next number (201029) automatically.
How do i find the next (maximum) number in this list, so i can increase by 1 and use????