query not working

[Patrick]

I have 2 tables I am trying to pull data from and am only getting one set of
data. table 1 has primary key of palletno. There is a pallet of product
produced and there is 1 sometimes 2 referenceno for each pallet. Each
referenceno is in table 2 that has fruitid as a primary key. There are 10
bins of fruitid per pallet with 1 referenceno. If there are 2 referenceno's
then there are 20 bins of fruitid per pallet. When I run my select query I
get only 10 bins of fruitid. It is set up in table 1 as palletno, date
dryed, lotno, #casestableA, #casestableB, referenceno, referenceno2. Table 2
has fruitid, date filled, customer, netweight, referenceno, referenceno2. I
want the query to pull by palletno all the fruitid associated with it. Is
there any easier way to perform this?

 

[scubadiver]

Does table2 have a "palletno" foreign key field ?

 

[Patrick]

no palletno foreign key
If I create a palletno foreign key how do I get the palletno in table2? Is
there a query or something to add the palletno to table2 so it doesn't have
to be entered?

 

[scubadiver]

How did you design your query?

 

[Patrick]

table1 is titled "finished product table"
table2 is titled "fruit inventory"
The relationship is with the referenceno and referenceno2
This is a select query with "finished product table" fields of "customer",
"Palletno", "lotno" and "date dryed" and from "fruit inventory" table fields
of "fruitid", "date filled", "customer", "netweight", "referenceno" and
"referenceno2"
I am working with access 2002.