I would like to generate list of values from related field but with empty and non-empty values. Standard List() function removes empty values. I was looking for custom function but didn't find any good one.
For now I just edited awsome CustomList custom function so it doesn't remove empty values. It works but I feel that is a to much code for such a simple problem.
Can you recommend me any solution for that problem?
ExecuteSQL ( "
SELECT \"name\"
FROM RelatedValues
WHERE \"_mainTableID\" = ?
" ; "" ; "" ; __IDpk )
This calculation can be stored but if so value will change only when __IDpk is changed.