I don’t need someone to solve this for me, just point me in the right direction:
I have a field that will be in the form of an array like this:
a,b,c;d,e,f; etc. I want to display the contents for each record in a columnar list like this
a b c
d e f etc.
I know how to make a text list in which the columns contain different fields for all the (or the selected) records in a DB. What I can’t yet figure out is to make a list out of this field from just one record, to display on a form displaying that record.
An extra bonus would be that if any of the array elements were a number I could sum it at the end. I think that would involve extracting that element from the array in the field, converting it to a number, etc.
So it seems like my question is about dealing with an array that is a constant within a field rather than constructing one from the whole DB (or a selection within it).
I’ll appreciate any hints that put me on the right track; it seems that this should be pretty simple.
Thanks in advance,