Obsoleting Products in Ordering Database

[Kereng]

I have a simple ordering database set up with product codes and their descriptions, etc. in one table (and the 'product code' field as the primary key) and then a separate table for the orders raised.

When a product becomes obsolete, I would like to be able to prevent anyone from raising a new order against that product code. I can't delete the code from the 'product codes' table as there are related order records against it.

Is there a way to make this code obsolete so new orders can't be placed for it, but keep the previous order records?

 

[Galaxiom]

Add a Boolean field to the table to indicate Obsolete. Then change the query that offers products for ordering so that it excludes the Obsolete procucts.

 

[Kereng]

Thanks for the reply. However, the link between the products table and the 'order form' is simply a relationship link between the two tables, so I'm not sure if what you're suggesting would work?

I also don't know how to add the boolean field. Sorry, I have very little Access experience.

 

[Galaxiom]

I expect you would have some way to choose the product from a listbox, combo or subform. Change the RowSource query to omit the obsolete products.

If they are just entering the product code directly, use a validation (eg a Dlookup) to detect that the product is not obsolete before accepting it.