I have an invoice setup that I want to total up the item amounts. I have a checkbox for the line items for if they are taxable or not. I want to total them up seperately. I think I can do this by setting a global value for either of the taxable options (either taxed or not) and setup a second relationship between the tables using both these fields (the unique id and the taxable fields).

I was just curious if any one knows of a better way so that I don't need the global fields.

Thanks

You could use two calculation fields in your line items table.

cAmtTaxable => Case( taxable = "yes"; Amount )

cAmtNonTaxable => Case( taxable = "no"; Amount )

Then two calcs in your invoices table,

cTotTaxable = Sum(rel::cAmtTaxable)

cTotNonTaxable = Sum(rel::cAmtNonTaxable)

So it depends if you prefer to add globals and relationships or calcs.