Topic: Ask for help with calculations.
The value of sql does not appear.
My Visual Database → FAQ → Ask for help with calculations.
The value of sql does not appear.
Hi,
I think the syntax for your calculated field should be
(
select sum(qty) from ininfo where prdinfo.id = ininfo.id_prdinfo)
)
Also, you don't need id_ininfo in the prdinfo table (I imagine it's just a one-way relationship).
Regards,
Derek.
My Visual Database → FAQ → Ask for help with calculations.
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi