M
Meredith9053
Hi, I am new to forum posts, but have reached last resort, - have flat spot
in my head from beating on brick wall! LOL.
Need to build a query ( I think) for a database and cant work it out!
Scenerio.
Have product table, with usual fields, ie product name, description, unit
price, special price etc.
Have a form for customer orders with a subform in it for product name,
description qty, unit price and line total.
Two problems, first is:
Would like to see when I select the product i want in the product column
from the combo box, the product description to be automatically filled in
that corresponds with that product. ie - product name, AUSMUG, then product
description to show Australian Mug.
Second Issue:
With my database I have three types of price in the Product List Table, the
Unit Price the Bult Price and a Special Price. Would like to create a combo
box that supplies me the prices in my products table, that relate the AUSMUG.
Also would love if the combo box had headers. ie. would like to hit the
drop down box in the Unit price column and see three columns, each labled
Unit$, Bulk$, Special$ respectively, then the price under each heading.
Just another thing, while I am here. with the Line Total
Thats it, sounds simple, but I must be barking up the wrong tree.
in my head from beating on brick wall! LOL.
Need to build a query ( I think) for a database and cant work it out!
Scenerio.
Have product table, with usual fields, ie product name, description, unit
price, special price etc.
Have a form for customer orders with a subform in it for product name,
description qty, unit price and line total.
Two problems, first is:
Would like to see when I select the product i want in the product column
from the combo box, the product description to be automatically filled in
that corresponds with that product. ie - product name, AUSMUG, then product
description to show Australian Mug.
Second Issue:
With my database I have three types of price in the Product List Table, the
Unit Price the Bult Price and a Special Price. Would like to create a combo
box that supplies me the prices in my products table, that relate the AUSMUG.
Also would love if the combo box had headers. ie. would like to hit the
drop down box in the Unit price column and see three columns, each labled
Unit$, Bulk$, Special$ respectively, then the price under each heading.
Just another thing, while I am here. with the Line Total
Thats it, sounds simple, but I must be barking up the wrong tree.