Topic: calculated field
I have 3 tbale, table family, table member and table sector. I need script calculated field in table sector sum from field calc in table family.
please help me
My Visual Database → General → calculated field
I have 3 tbale, table family, table member and table sector. I need script calculated field in table sector sum from field calc in table family.
please help me
Hi Agusecc,
Calculated fields cannot reference other calculated fields - so in this case, you need to do a 'select' within a 'select' in your calculated field.
Try it like this (please see attached).
I also added a couple of 'dbupdates' to your script (which you often need to do when using calculated fields) so that you see the changes immediately in form1.tablegrid1 and form1.tablegrid3 otherwise you need to restart the program.
Regards,
Derek.
Thanks you Derek
My Visual Database → General → calculated field
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi