Self Join Calc

[Genx]

... righto just a small problem / query... i have a table set up with an id and a global store field.. when you execute a script, the id is added to the global... now ive made a self-join relationship between the global field and the id...

basically, how do you check if the id is already in the global returning a 0 if its not in the list or 1 if it is..?... lol work around but hey...

cheers, genx

[comment]

Try:

Position ( ¶ & list & ¶ ; ¶ & item & ¶ ; 1 ; 1 )

or:

not IsEmpty ( FilterValues ( list ; item ) )

[Genx]

hmmmm, perfect

cheers