Topic: Calculate Field Script?

Hello MVD please help me
I have three table, 1. table jurnal, 2. table Akun 3. Table jenis_saldo
On Tbale Jurnal I have two calculate field  (debet and kredit) from tabel Jurnal.saldo  join with jenis saldo

debet, Currency

(select saldo from jurnal left outer join jenis_saldo on jurnal.id_jenis_saldo = 1 where jurnal.id = jurnal.id) 

but this script is wrong...

please see attachment

Post's attachments

Attachment icon Accounting.rar 295.17 kb, 181 downloads since 2021-03-26 

Re: Calculate Field Script?

Hi,
Try it like this (see attached).
Derek.

Post's attachments

Attachment icon Accounting2.zip 338.84 kb, 273 downloads since 2021-03-26 

Re: Calculate Field Script?

Derek,  Thanks you Very much
calculatefiled  work well...
Awesome..