Topic: calculated field in the database
how do I in a field calculated within the database, to have the sum of a quantity of a product in a single product id
My Visual Database → General → calculated field in the database
how do I in a field calculated within the database, to have the sum of a quantity of a product in a single product id
example: in an invoice I have a product 100 pieces I make 2 discharges of 50 pieces, how can I sum 50 + 50 = 100 in a single product ID inside a calculated field?
example: in an invoice I have a product 100 pieces I make 2 discharges of 50 pieces, how can I sum 50 + 50 = 100 in a single product ID inside a calculated field?
Table.product1+Table.product2
does not work
I make 2 invoices of 50 apples per total invoice I have 100 apples, now how can I show the total of the 2 invoices in a TableGrid without showing me the same product twice, since it is the same ID?
Hi Domebil,
Does doing it like this help you? (see attached).
Derek.
Thanks a lot! it works great
Derek
My Visual Database → General → calculated field in the database
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi