G
Guest
I have a form based on the table Retail Box Detail Master. I am entering the
items being returned in each uniquely numbered box. My form as the following
fields.
Box Number
Item Description
Internal Item No
Quanity Returned
Packgaing Return (each, pack, box, brick)
When the Item Description is typed in the Internal Item No auto populates.
Here is my delema some of our products are names the same, but have different
internal item nos. for example 1 3/4" Firecracker Rolls (i have four of
these each from a different company). When I select in my field Item
Description (combo box based on a query) 1 3/4" Firecracker Rolls with
Internal Item No 539, my Internal Item No field produces the #507 which is
the first of the four prodcuts with the same name.
Why if I specify in the Item Description combo box 539 will it no populate?
items being returned in each uniquely numbered box. My form as the following
fields.
Box Number
Item Description
Internal Item No
Quanity Returned
Packgaing Return (each, pack, box, brick)
When the Item Description is typed in the Internal Item No auto populates.
Here is my delema some of our products are names the same, but have different
internal item nos. for example 1 3/4" Firecracker Rolls (i have four of
these each from a different company). When I select in my field Item
Description (combo box based on a query) 1 3/4" Firecracker Rolls with
Internal Item No 539, my Internal Item No field produces the #507 which is
the first of the four prodcuts with the same name.
Why if I specify in the Item Description combo box 539 will it no populate?