Incremental Text-Number

[mlozano]

Hi
I have a db to manage order processing
My orders are identified with 2 letters (which the user inputs first thing as they insert a record, a 2-digit number and the current year.

I would need Access to provide an incremental number that takes into account numbers used only with the same 2 letters the user has selected.
For instance, if the orders RE100-2009 and MA101-2009already exist, and the user selects RE for the new request, the new number shhould be RE101-2009

How can this be done? Any help will be greatly appreciated as I am quite lost at this point

Cheers

 

[ajetrumpet]

this is too complicated to explain on a web. upload a sample and someone will take 5 to show you how it works.