September 1, 201015 yr 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
Create an account or sign in to comment