February 11, 200223 yr 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
February 12, 200223 yr 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.
Create an account or sign in to comment