need advice of estimating program structure

[The Big Bear]

Hi all

I would like for advice on the structure of an estimating program we are starting to work on. I have the basic written down and included a PDF of what is will look like.

The first layout has about forty or more fields with about 2/3 of the fileds being unique to that particular item wich would be the main component.

The second filds has a bout thrity fileds. These two layout have only about 5 or 6 fields in common.

The question is, Would your use one table too house all the records although many fields would not be completed per record for a component.

example

a separate table for LWN

a separate table for WN Flanges

a separate table for Steel Plate

a separate table Misc information

but all these tables would have one record or more records for each component.

thanks in advance

Lionel

estpdf.pdf