query not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
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.
 
Back
Top