I have a Products database that includes Manufacturer and Product Name. It also has a Deactivated field. Checking this field would allow the records to remain in the database, but not be

To display the list of Manufacturers, I would create a table that contained a master list of each. That would allow for a simple portal view to summarize each Manufacturer. Then create a script that picks up the ID from the manufacturer, from the portal row, do a 'go to related record-show only related records' in the main table which displays all the product names for each... then you can use the Replace function to insert a value or calculation result into any given field... i.e. toggle the deactivating/reactivating all the products.

sdpetemc-

Thanks for the suggestion - that certainly could work.

I had been mulling it over since I posted it - and was thinking there might be a self-join that would do the trick too. I'm off to go experiment both ideas and come to a decision - unless you or someone else has a better idea. ;-)

Thanks so much,

Mark