I am trying to write a query in Access based on the following:
Table 1 has one item with a serial number (primary key). Each item has Table2_lot1, Table2_lot2, Table2_lot3 etc.
Table 2 has one item with a lot number with multiple test values.
Each item in table one may have multiple matches in Table 2 as up to 3 lots can be used on item 1.
I would like a query where I could input the Serial Number from Table 1, and get all lot numbers and test data from table 2. I am really stumped by this, not being a full-time programmer.
Any help would be appreciated.
Table 1 has one item with a serial number (primary key). Each item has Table2_lot1, Table2_lot2, Table2_lot3 etc.
Table 2 has one item with a lot number with multiple test values.
Each item in table one may have multiple matches in Table 2 as up to 3 lots can be used on item 1.
I would like a query where I could input the Serial Number from Table 1, and get all lot numbers and test data from table 2. I am really stumped by this, not being a full-time programmer.
Any help would be appreciated.
Comment