Search results

  1. O

    Many to Many tables

    I have been playing around today, and have managed to get a scheme up together. The problem now is that I can only have one instance of a ProductID per SoftwoodID. What I need to do is be able to have many of the same ProductID in the one table, if you know what I mean! Do I need another...
  2. O

    Many to Many tables

    Thanks TheDocMan, I have revised the plans slightly, but still need guidance. Down the left I will have Studwork, Rafters, Bracing, across the top I wil have ProductID and Quantity. It all needs to link back to ClientID in another table. I am playing with relationships at the moment, but can't...
  3. O

    Many to Many tables

    Hi guys, I am having a bit of trouble designing a table layout for a complex form. What I have is softwood order sheet with rows down the left for types of timber, ie studwork, bracing, rafters, etc. Across the top I have headings for timber size (47 x 100 or 47 x 150, etc) timber length (2400...
Top Bottom