I am working with a product database where we have items that are discontinued. we need to keep them in the system for future reference, however they are in the way. I have created a field "productstatus" where the items can be marked, available, coming soon or discontinued. I would like to possibly set up a script where we find on the manufacturer of the product and the discontinued items are automatically removed from the find results. I'm not sure that this is possible. Does anyone have any suggestions?

Yes, you could do that, but you might also consider setting up a separate DB for discontinued items. Once an item is discontinued, export the record to that DB, and delete the original record. Now it is out of your way. If someone wants to find a discontinued item, script the search to go to the discontinued database.

-Stanley

You can easily omit discontinued items in every scripted find. Just make sure to append the find requests with an additional constrained request to omit discontinued items.