This topic is 3213 days old. Please don't post here. Open a new topic instead.
By cat traveller
for days I am trying to figure out how to do this- maybe it is easier then I think:
on a multiuser enviroment all on fm pro 11, I would like to use a mix of the virtual list technique (bruce robertson?)
with displaying related data for input through a portal.
Anyhow what I would like to do is this:
create a multiline key to display data that is filtered dynamically.
parent connected to child via x cartesian
the field I am listing displays two fields in one line like so: categorykey||keychild
The list will retrieve no more then 6k records max.
Now what I would like to do is remove all the lines from the list that don't have a "selected" category in them
then I would like to remove all the left (list (Position (list ; "||"; 1;1)-1 from the list, giving me a clean multiline key
to set as the starting point for my portal to display.
I read something like this but I cannot manipulate it properly. Can anybody please help? I am not good at recursive functions...
The reason for doing this instead of a search and omit and getnthrecord values is my worry about speed for the users over wan.
Who Viewed the Topic