Search results

Thanks Rainlover, fortunately, or unfortunately, I will be the only one using the DB :)

Got it!! Added a field to capture the entire customer name, no duplicates. Added a line in the code (after it checks for data) to copy the entire name into the new field. Then added a line before the DMax line to grab the first 3 letters. Thank you everyone for your contribution!!

Thanks Everyone. The DMAX solution seems to be on the right track, but needs to be comparing/incrementing only the first 3 letters. The actual full name needs to be unique. Energy - ENE01 Enertry - ENE02 Enertime - ENE03 etc. I added a field (myLetters) to the DMAX Plus One solution, and...

I was able to do this, unfortunately the people that will be using the DB want it automatic. As our customers come on board, they don't want to have to remember, or look up, if the 3 letters have already been used, and if so what the current number was. As an example, an initial customer was...

This is great! This solves the second part of my problem without any extra work.... I still need to generate the customer code to begin with. I'm not an expert either and I'm assuming/hoping that I can figure out how to use the same code to generate customer code (commodity type in the sample)...

Hello, hope someone can help me this problem. I am in the process of creating a DB for customer names, job numbers and document numbers, but have run into a problem right from the start. We are using a naming convention of the first 3 letters of the customer name, and 3 numbers after that. Eg...