[AccessD] Quotation Database structure question

Richard,

I have a similar situation where I work.  We have production shop order
forms that have some common elements (project, quantity, item name,
department, etc) but the actual details of the order are different depending
on whether it's a graphic or something that needs to be fabricated.

What I did was set up individual tables to hold the non-common information
and used the PK of the common element table as the FK to the non-common
tables.

>From an interface standpoint, you could use a mainform-subform approach to
show the appropriate subform of non-common information based on the
component type selected on the mainform record.

Doris Manning
Database Administrator
Hargrove Inc.