Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by burkepl

  1. burkepl

    Sorting Data using Queries

    The information is still contained in those tables (tblDuctbank and tblCircuits). The only important information contained in each table is for tblCircuits the ductbanks numbers and for tblDuctbank the circuit numbers. +Ductbank ID Ductbank CIRCUIT 1 CIRCUIT 2 Ductbank 5 4DB08C1...
  2. burkepl

    Sorting Data using Queries

    tblDuctbank Ductbank ID Ductbank CIRCUIT 1 CIRCUIT 2 Ductbank 5 4DB08C1 4PPAK2008013 4PPAK2008015 Ductbank 6 4DB08C2 4PPAK2008021 4PPAK2008026 tblCircuits Circuit ID DBCircuitsLeft Ductbank 1 Ductbank 2 Circuit 240 4PPAK2008031 4DB08C1 4DB09A1 Circuit 241 4PPAK2008032...
  3. burkepl

    Sorting Data using Queries

    I started organizing the data like in the last post, this is an example of what I did. DCID Circuit ID Ductbank ID 10 Circuit 1 Ductbank 284 11 Circuit 1 Ductbank 204 12 Circuit 1 Ductbank 130 13 Circuit 1 Ductbank 62 I had to manually go through and enter each circuit 1 under each ductbank...
  4. burkepl

    Sorting Data using Queries

    As it is, each circuit has one record in tblCircuit and each duct has one record in tblDuct. The other information contained in the other fields is the information that I'm trying to correspond to. It would be very labor intensive to organize each case of one circuit and one ductbank, unless...
  5. burkepl

    Sorting Data using Queries

    Ok, here's some corresponding data. Circuits Ductbank 1 Ductbank 2 4APCE1012003 4DB21A4 4DB19I6 4APCE1012004 4DB21B4 4DB19G7 Ductbanks CIRCUIT 1 4DB19I6 4APCE1012003 4DB19G7 4APCE1012004 So for this example, there's multiple...
  6. burkepl

    Sorting Data using Queries

    Alright, so I've got my CircuitID and DuctbankID and their corresponding tables set up. I'm not sure how to create the tblConnection with the common fields. example where RWY is the ductbank primary key in the Duct to Circuit table. RWY CIRCUIT 1 CIRCUIT 2 4DB19B4...
  7. burkepl

    Sorting Data using Queries

    Thanks, I am new to access. I'll look into the normalization but the many to many relationship is exactly what I am talking about. I'll let you know when I come to a roadblock.
  8. burkepl

    Sorting Data using Queries

    I have two tables, one contains all of the circuits and then each individual circuit shows all of the related ductbank in the next column. The other table is the opposite, it contains all of the ductbank in the first column and the second column contains all of the ductbank that it goes...
See more

Part and Inventory Search

Back
Top