discontinued product

[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

 

[Dirk Goldgar]

In

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

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.

 

[Guest]

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.