Database Design

[LzAnn]

To help with part of a larger project, one facet of estimating for plumbing jobs:

A building can have many Soil Vent Pipe (SVP) stacks. Each stack feeds a certain number of bathrooms and kitchens. Each SVP is numbered on a drawing, SVP1, SVP2 , SVP3 etc. The list hand written for each estimate is like this:

SVP1 – 2 bathrooms and 1 kitchen
Ground floor fittings needed:
Qty Name Code Size ListPrice Total

2nd floor fittings..
Same as first floor

3rd Floor:
Qty Name Code Size ListPrice Total

SVP2 – 3 bathrooms and 2 kitchens
Ground Floor
Qty Name Code Size ListPrice Total

1st Floor
Qty Name Code Size ListPrice Total

2nd Floor
Qty Name Code Size ListPrice Total

Etc…

Can anyone advise how a db table structure and relationships for this section of an estimate would look? Would be extremely appreciated.

Thank you very much J

 

[PNGBill]

If your question is about how to view / present a quote then you could do it by adding a field to your QuoteDetailTable. (this may well be the same table you use for InvoiceDetail. The field would allow you to enter the "Section" of the quote. It could be typed in or if there is a limited number of choices then have a table of these and use this table as the record source for the Section text box control on your quotation form.

When you send the quote to a Report, use Group and Sort on your report and the quote records will be in their respective Section (put Section in Group Header so only shows once) and you can have Sub totals and Grand totals.
Report handles this quite well, not much work for you once it is setup.

You can do calculations in Forms and Reports, Sum etc

PS you do all this "group" in your Form so it looks like the Report and then just save the form as a Report and Wala, two jobs done for the work of one.