UKenGB
-
Determining if children exist
In various places I have used the construct:- if 'children table ref field' then do something end In fact I sometimes hide an empty reference field to the child table by putting the reference field…
-
MAJOR problem (v3.7.14 Mac)
Made some changes yesterday for first time in a few months. Made some minor structural modifications and went through a fair bit of data, updating to suit the changes (a new field or 2).…
-
Array trouble after update
I have some code that creates 2 arrays of records, which I then combine thus:- array(thoseDirect, thoseDupes) The combined array then gets used in a Dynamic Choice field.…
-
Dynamic Choice as table list/View column
let's say I have a column 'Quantity' in a table/View. I then add/Show a formula column calculated as:- if Quantity = 1 then "one" else "other" end In this case,…
