Need Help with Concepts (FILTERS and JOINING TABLES)

[Amanda V]

Hello,

I've created a database with some one-to many relationships.

One table has some "generic sample data" (name, manufacturer, type) It
is organized in bacthes (name manufaturer and type will always be a
unique combination) . it is connected to another table that holds only
two fields "Sample Number" and "Batch Number" this is used to connect
the first table (generic sample data) to a table where test data is
stored.

So "generic sample data" applies to 20 samples ( 20 samples in one
batch), and those 20 samples are each tested 10 times. So in my 3rd
Table, tblTestData, I store the sample number and all the sample data
for each test (another field has data for test1, test2 ... test10).

I have then run a search with a filter to find all data pertaining to
certain "generic sample data", how can I somehow join the first and
third tables, to return all of measurements done on each sample given
the user dictated "generic sample data". I want to be able to specify
the Batch number, and return all test data that falls into that batch
for each of the 20 samples.

I hope this question makes sense, I can clarify if need be. I think I
just need to be pointed in the right direction in terms of theory
behind using a filter and joining two tables that are not directly
related.

THANKS
Amanda

 

[Marshall Barton]

I've created a database with some one-to many relationships.

One table has some "generic sample data" (name, manufacturer, type) It
is organized in bacthes (name manufaturer and type will always be a
unique combination) . it is connected to another table that holds only
two fields "Sample Number" and "Batch Number" this is used to connect
the first table (generic sample data) to a table where test data is
stored.

So "generic sample data" applies to 20 samples ( 20 samples in one
batch), and those 20 samples are each tested 10 times. So in my 3rd
Table, tblTestData, I store the sample number and all the sample data
for each test (another field has data for test1, test2 ... test10).

I have then run a search with a filter to find all data pertaining to
certain "generic sample data", how can I somehow join the first and
third tables, to return all of measurements done on each sample given
the user dictated "generic sample data". I want to be able to specify
the Batch number, and return all test data that falls into that batch
for each of the 20 samples.

I hope this question makes sense, I can clarify if need be. I think I
just need to be pointed in the right direction in terms of theory
behind using a filter and joining two tables that are not directly
related.

You need to join all three tables so you have a complete set
of data.