Update multiple records in a table based on a filtered form.

Legacy Contributor

Has anyone created a form where the users is able to filter records on a single table then update records in that table based on free text fields on that form. For example, I filter for a site on an item form and I want to have a button that updates the price of all items on that form by a percentage. 

Thank you. 

Legacy Contributor

The pattern to follow is likely something like how the Change Cost Rates form works. You can add a field for the percentage to pass to the procedure that does the actual update.