Recent content by maildodge

Thanks :D Cheers for the quick reply Popeye and the modified file. WayneRyan, thats exactly what I needed. I said it would probably be simple. Thank you so much. It has taken me so long trying to figure it out, I actually had something similar to that earlier today but just a bit missing...

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...

Think I finally got it sorted thanks to all you guys. Again thanks for the help and the examples. :D

It would be some time until Z9999 got used. But after that I think the database would have to be restarted (I know not perfect, but dont want to worry about that yet) Thanks for advice given. Im going to try playing around with what you both have said. But not sure how to do it :eek: Think...

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...