Hello everyone,
I'm trying to accomplish something similar to the List function (available in a 4GL I will not name ) in Servoy, which would fetch a list of related values in another table - I would then need to separate each value with a comma, similar to this:
ClientA Items 3, 14, 67, 82
ClientB Items 4, 9, 12, 44, 67
etc.
I've got my calc field all set up, but I just get the first related value for each record. I'm assuming I must use an array here, and I've tried using the getValueListItems function without success (it does say in the manuals that it's not recommended for related values, I know...). Can someone point me in the right direction here please, calc-wise?
Also, is there a quick and dirty way that I could strip off the leading zeros in my comma-separated list? They would actually look like this if I just went and got the values:
ClientA Items 003, 014, 067, 082
ClientB Items 004, 009, 012, 044, 067
etc.
TIA,
Ben