In your line items file, create fields for the amount for each category. For instance, if the item is pine and the amount is $450, the category field would be wood and the Amt_Wood field would be set to:

Case(

Thanks for that, It works a treat had a minor issue with the relationships but once fixed sweet.

I'm trying to create summary info from portal fields.

I have a quoting system which I need to show summaries of the different catergories, so that my sales people can print either a itemised Quote or Simple final Total. No problem with the final total, it's by category that's stumping me.

example

Paint $300

Wood $450

Concrete $300 etc etc,

however when we build up the quote their are several items associated with one catergory.

i.e Wood contians different types Pine, Rimu etc.

I have a Line_items DB and a sep Inventory DB with (i hope) the appropriate relations set

any ideas please.