Filemaker 9 or earlier: You can set up your check box field as a button so that clicking it triggers a script to do what you want. It can check the value of the field to determine whether it is adding or deleting a record.
Filemaker 10: you can set up the field with a script trigger that performs a script when the field is modified.
Well on my line items I got
Product ID Category Product description Product Quantity Days Product unitprice Subtotal
We rent out stuff so everything is a set price but we got a seprate price when they lose somthing a L/D price. I want to make a Button in the Portal That scripts it to Take the L/D price from the products list and replaces the product unit price and change teh category to "Lost" or Damage since that has a diffrent price aswell. maybe use a check box with scripts? any tips?
Btw there all connected by the Invoice ID