Search results

I have a table with Customer Code and Customer Name. And a second table with details of Order. Basically I need to be able to input/choose the customer code in the order form and for the customer name to be automatically filled. Im sure its very simple, for some reason I cant get my head round...

Ok, I know you cannot have an autonumber with text. But I need an order number to be created that automatically increases, the catch is it also needs a letter infront of it, eg.. D0001, D0002, upto D9999 then it will move onto: E0001, E0002, upto E9999 etc. Is this possible? To be honest...