How to valid a record in a table

[barbaras]

Hello,

I've records where the User enter Product Name, Reference, Price, etc.. I've an Administrator who accept or not the record for futur order. I would like to valid the records using a Table. Until now, nothing very difficult, I added a checkbox field in the Table. BUT, I would like to have (in the footnote for instance), the Total price, on the fly, of the validated record. For example, if I check 3 records I would like the total price of the 3, and if I change my mind the total price of 2 or 4 etc..

Thank you for your help

[Fitch]

Think of your checkbox as a quantity field. When you check the box you are giving it a value or quantity of 1; no check is a quantity of 0. To get the extended price of a line item, you would multiply the price x quantity:

price * checkbox = ValidPrice

Now change your Total to add up the ValidPrice field, rather than just the price.