P
Patrick
I have 2 tables that I am trying to query from. I have a table "finished
product table" and a table "fruit inventory". Each table has a field
"referenceno" and "referenceno2". "fruit inventory" has a field "lot-bin#"
and "finished product table" has a field of "pallet number". I want to query
by "pallet number" to pull all "lot-bin#" used to make up the pallet number.
The primary key in finished product table is pallet number and the other is
lot-bin#. When I run the query looking for pallet number I should get 20
items returned, with 10 being from referenceno and 10 from referenceno2. I
get 10 from referenceno and nothing from referenceno2. What am I doing wrong?
product table" and a table "fruit inventory". Each table has a field
"referenceno" and "referenceno2". "fruit inventory" has a field "lot-bin#"
and "finished product table" has a field of "pallet number". I want to query
by "pallet number" to pull all "lot-bin#" used to make up the pallet number.
The primary key in finished product table is pallet number and the other is
lot-bin#. When I run the query looking for pallet number I should get 20
items returned, with 10 being from referenceno and 10 from referenceno2. I
get 10 from referenceno and nothing from referenceno2. What am I doing wrong?