you can have your tables filed in easy enough,but what do you want the drop
downs to do??Do you want the register to eventually "cull" the drawings as
the drop downs are used,but no drop downs used during the input???

Your numbers dont make sense. How you can have a single letter identifying
63 types or a single digit identyfying 30 different types?

sounds interesting!I have comboboxes from the forms toolbars that repopulate
other comboboxes or option buttons that do the same thing.Could the last two
numbers be actual sheet numbers within the series??
--
paul
remove nospam for email addy!



"Boab1965" wrote:

I'm creating a drawing register for a project i'm working on. An
example of the existing number system is BMI8813A where BM is the Site
code, I is a drawing type , 8 is a drawing identifier, 81 is an
equipment identifier and the 3A i'm still trying to figure out.

There are 63 different drawing types and approx. 30 different drawing
identifiers.

I have a list of drawing types with the 2 letter code and the drawing
description. I would like the register to have a pull down box that
displays the drawing type description but when selected adds the 2
letter code in the spreadsheet.

I'd prefer to stay away from VBA and combo boxes to make it easier for
the users filling in the register.

I'm not sure that the data validation is the correct way to go.

Thanks for any help

B