Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2012
    Posts
    2

    Unanswered: relationship between 3 tables??

    I've got 3 tables with a material number common in all three
    1st tbl is material specs material number can not be duplicated
    2nd tbl has material number duplicated as it can be used multiple times through the day ingredients used for blends
    3rd tbl has material number duplicated as it can be used multiple times through the day ingredient samples tested for fat ie,
    Thanks Doug

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Do you have a question?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Mar 2012
    Posts
    2
    i have data in all 3 tables and would like to have a query that takes the data from tbl2 and select the data from tbl3 that matches the material number an batch number with the test results from table 3. when I try to set a relationship it gives me all the data from tbl3 or tells me to make a query first. I'm having trouble trying to figure out how to put a common link to all 3 tables or if I even need to.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •