Design Help???

S

Steve

Ok guys, How should I go about doing this? I have to create a Drawing
Database which I will assign drawing numbers and give descriptions of the
drawings. The thing is. There will be 9 different types of Drawing. Assembly,
Weldments, Parts, Installation, Schematic, Layout, Spec's, Calculation,
General. Each will be given a special number, example. Assembly = 7151000,
7151001; Parts = 7351000,7351001. What I want to do is create a form for this
purpose. I would like to autogenerate the numbers upon a combo box selection
of type of Drawing and autofill the Drawing Number Text box with that number.
Any suggestions would be greatly appreciated.
 
T

TC

Steve, you need to ensure the table design is correct, before you worry
about the forms & reports.

For example: do you need to record a drawing /structure/, as in a bill
of materials? If so, you will need to allow for this in your table
designs.

I suggest that you tell us the fields that you propose for each of your
tables. We only need their names, not their types & lengths. It is also
critically important to select the right *primary key* field(s) for
each table. If you don't know what a primary key is, you need to stop
right here, and go research that term, before you even *think* of going
any further with the forms & reports.

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
Top