Complex Script

[stuj1026]

Hi Everyone

I am in need of a script that I just can't figure out.

I have a field1 with this

jim

steve

mac

sue

In field2 I need the output to be

jim

jim steve

jim mac

jim sue

jim steve mac

jim steve sue

jim mac sue

Jim steve mac sue

steve

steve mac

steve sue

steve mac sue

mac

mac sue

sue

I know it's done in loops but the logic escapes me.

Thanks for all your help

Stuj

Edited June 21, 2010 by Guest

[LaRetta]

Hi Stuj,

It would help to understand why you want this. And are you really using people's names or is this only for example? It would help if you give us your real situation. I would think you are looking for relationships instead and are you really still on vs. 7? :smile2:

[stuj1026]

Hi Laretta

I am trying to duplicate within filemaker a tag system similar to the way it is done on delicious.com

[Lee Smith]

Your descriptions seems to be the same as this thread, see if this helps

Link and be sure to look at the file by Søren Dyhr

Lee