0
How do I update this code to auto create a new record in sub table balances that will link back to its parent - funds
let Nyear := last(Balances.Year) + 1;
let Nbeg := last(Balances.'Temp. Restricted');
let Nperm := last(Balances.'Perm. Restricted');
let i := (create Balances);
i.(Year := Nyear);
i.('Beginning Balance' := Nbeg);
i.('Perm. Restricted' := Nperm)
5 replies
-
let currentRec := this
let Nyear := last(Balances.Year) + 1;
let Nbeg := last(Balances.'Temp. Restricted');
let Nperm := last(Balances.'Perm. Restricted');
let i := (create Balances);
i.(Year := Nyear);
i.('Beginning Balance' := Nbeg);
i.('Perm. Restricted' := Nperm);
i.(Balances := currentRec) -
Sorry, line 9 is returning field not found error. Any thoughts?
-
Sorry, i think instead of Balances in line 9 it must be the name of your parent table.
-
funds
-
Fantastic! Works perfectly!!!
Content aside
- 5 yrs agoLast active
- 5Replies
- 1417Views