remove on obsolete

[krishnanhemanth]

hi all

i have a table "bom" which lists all the partnumber used in an project.
these are the following details
fields in bom
partnumber
partname
qtyreqd
obsolete -------- yes/no field

i use the field "partnumber" in lot of other places like placing a order, billing, stock etc... and the rference is from the "bom" table

the requirement
if a particular partnumber is declared obsolete, then that particular partnumber should be disabled in all the combobox for any new records but....
at the same time all the records that have already used this partnumber should remain intact
how do i do this

pls help
hemanth

 

[DCrake]

If you are using textboxes to select the part number then you will have to use the before/after update event to check if the part number is obsolete, generally by using a DLookup() command. However if you are using a combo box, the preferred method, then in your recordsource make sure it's Where Obsolete = False is in the recordsource. This will ensure that the user can oly select active part numbers.

 

[krishnanhemanth]

thanks dcracke
thanks for the solutuion but...

will it alter my previous records that have already used this partnumber

 

[DCrake]

No. If you apply the restriction on the form where the user is adding part numbers to an order via your bom then its fine. However if a user wants to edit an existing order then you will have to remove the restriction in case the order includes a previously active part number that has now become obsolete.

In general parts need to be stocked for serveral years before you can make them obsolete anyway so the likelyhood of wanting to revise an old order will be minimul.

What shelf life have your parts got?

 

[krishnanhemanth]

sometimes on a product there are value additions or improvement on a particular part or a better replacement for a existing part.
these are the times when a particular partnumber becomes obsolete