Hi all..I'm new here..so far enjoying this forum.

My problem is that i have 1 database with inventory and other for inputs in the inventory, ex. we buy 1 toner for epson and we introduce it there.

Question is how do I, in inventory, sum the records entered for tonner epson to keep the inventory updated.

Using sum, it sums all entrys not only epson toner.

Maybe its very simple...but not getting there.

Thank you in advance to any that can help.

You need a relationship between Inventory and Inputs, which filters the records you want to sum. Probably the best will be to define a global field in Inventory with a valuelist of all product names. You maybe need two fields, if you want to refine the filter by brand (Epson) AND product type (toner). Then the formula for the will look something like:

Sum("TheNameOfTheTableOccurenceWithTheRelationship"::"NameOfTheFieldToSumUp")

This will sum only the records in Inputs, where the matchfield equals the value, you choose for the global field in Inventory.

Detlev Bruggmann

That worked perfectly...thank you very much for your attention