discontinued product

S

Simon

I currently have a database for my online shop, i use drop down menus
to select the product, this looks its up from qryProducts.

I now have discontiumed product so have a tick box in tblProduct then
qryProducts only shows non discontiuned product

When i go and place an order it only shows the products i only sell,
the problem i have if i go and look back at a previos order which has
a discontuned product it does not dispaly it.


Can any one give me a good recomendation on how to get around this


Thanks

Simon
 
D

Dirk Goldgar

In
Simon said:
I currently have a database for my online shop, i use drop down menus
to select the product, this looks its up from qryProducts.

I now have discontiumed product so have a tick box in tblProduct then
qryProducts only shows non discontiuned product

When i go and place an order it only shows the products i only sell,
the problem i have if i go and look back at a previos order which has
a discontuned product it does not dispaly it.

Can any one give me a good recomendation on how to get around this
Click to expand...

Offhand I'd say you need two queries: one for current products and one
for all products. Then when you're creating a new or open order, set
the rowsource of the product dropdown to qryCurrentProducts, but when
you're viewing an old, closed order set the rowsource to qryAllProducts.
 
K

Krazy Darcy

check the qryproducts query in design view. you may have a criteria for the
discontinued field that lets only non discontinued product appear in the
results.
Also do the same for the forms that show previous orders.
It might be something as simple as that.
 
Top