Search results

  1. L

    Product Descriptor Tables

    Greetings all database workers, I am still working on the table structure of a database to help my dad and brother with plumbing estimates. There are three tables relating to the Products table to store product details, defined as ‘Descriptors’. The descriptors are: Size, Angle, Flowrate...
  2. L

    Query: returns product data twice!

    Hello everyone! Am trying to create a query to combine relevant product data. Had lots of help on the tbl structure, thank you (jzwp22) :) The following fields return relevant products perfectly. ProductID, from tblPrducts ProductCode, from tblProducts ProductName, from tblProductNames...
  3. L

    Database Design

    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...
  4. L

    Designing Forms

    Help with Forms Hello everyone Am quite excited as this is the first time I have posted a thread :) Basically, I have been defining tables for a db to help us estimate jobs and be able to select products, so we don't have to write out the same information over and over by hand! Each estimate...
Back
Top Bottom