• Registered: 2015-12-19
  • Posts: 109

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

Post's attachments

Attachment icon FamilyAgusecc.rar 296.69 kb, 253 downloads since 2020-05-16 

2 Reply by derek (edited by derek 2020-05-16 09:41:13)

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: calculated field

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.

Post's attachments

Attachment icon FamilyAgusecc.zip 340.47 kb, 317 downloads since 2020-05-16 

3 Reply by agusecc (edited by agusecc 2020-05-17 15:29:45)

  • Registered: 2015-12-19
  • Posts: 109

Re: calculated field

Thanks you Derek