Stock levels

[David Swanson]

New to this access thing.Here's my problem.I have a stock
database up and running similiar to the Northwind but cut
right down.When I tick discontinued in my products table
it removes all traces of the product name from all my
forms and queries.I am sure there is a simple way to get
round this, could someone please help.

 

[Gary Miller]

David,

I think that is the purpose of the 'discontinued' flag so
that it is only available for historical purposes. They
designed it to hide like that, but not actually get deleted.

What are you trying to get around?

Gary Miller

 

[Al Camp]

David,
Not sure I understand...
Did you take the Northwind mdb, and "convert" it to your needs?
What do you want Discontinued to do?
Are you saying you don't want Discontinued to prevent displaying those
records on forms/reports/queries?
Please provide a bit more detail... if this next response is off the mark

All forms/reports have a table or query behind them. If your "borrowing"
those forms and reports from Northwind, you'll probably find a criteria in
those queries that says "Don't show the Discontinued Records". In the
Discontinued column of the query design grid ... you'll probably see a
criteria of....
False
or
No
or something similar.

That's what's causing the discontinued records to not show up. Just
remove the criteria, and all recs should show.

 

[Guest]

My database is based on the Northwind, but built from
scratch using some of the info as a template.My problem
is this.I have an order and order detail tables.I have a
YES/NO Discontinued box in my products table.when I tick
the discontinued box I want the the discontinued product
to be removed from the product list.This is happening
however it is also removing all previous records of the
product.
Sorry about the confusion.