My Visual Database — Calculate Field Script?

Re: Calculate Field Script?

null@example.com (agusecc) — Sat, 27 Mar 2021 03:49:53 +0000

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

Re: Calculate Field Script?

null@example.com (derek) — Fri, 26 Mar 2021 17:31:24 +0000

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

Calculate Field Script?

null@example.com (agusecc) — Fri, 26 Mar 2021 14:49:55 +0000

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