J
jwrnana
I have a report based on a query. Within the query are the Order table and
the Products table that include the fields - product code and product
description and product price. I want the code to be tied to the
description and price; i.e. I would like a "drop down" arrow to take me to
the selection of codes with description and price from the products table
so
that when I chose a code, the description and price automatically come along
with it. These fields however, are not listed in the same box, but
individual boxes (fields) for description and price. I do want to be
able to edit these fields.
I am a real novice and may not have made myself clear. Hopefully, I have.
Thank you for your assistance.
Joy
the Products table that include the fields - product code and product
description and product price. I want the code to be tied to the
description and price; i.e. I would like a "drop down" arrow to take me to
the selection of codes with description and price from the products table
so
that when I chose a code, the description and price automatically come along
with it. These fields however, are not listed in the same box, but
individual boxes (fields) for description and price. I do want to be
able to edit these fields.
I am a real novice and may not have made myself clear. Hopefully, I have.
Thank you for your assistance.
Joy