I have a database with only 1 table, 2 occurrances. I want to have it self-joined to show, in a portal, only the records in the current found set.

Seems simple, but I can't make it work!

How would you do it? Can you make it work in FM8???

Hi

with a script, that you can fire after a find.

Freeze Window

Go to Record/Request/Page[First]

Loop

Set Field[found;Get(FoundCount)]

Go to Record/Request/Page[Next;Exit after last]

End Loop

The auto-relationship is made from field: Found (number)

Daniele, this makes no sense. You've left out something. Each record in the found set would contain the SAME Get(FoundCount) in the Found field because it is the total of the found record set.

??

Yes, they do and so they will appear into the portal, just as SoCalMacDude wished

Since you are simply tagging each record (which is unpredictable in multi-user mode), why don't you just stick a 1 in the field - or an 'x'. It would work the same way. If this solution is served, Users will end up with each other's 'found set.'

I still believe that using a global to hold the IDs proves the safest, particularly with a process individualized per User on found sets which may change constantly.

But with vs. 8 and new GTRR flexibility (GTRR found set), it may be easier still. Nope. I wouldn't mark the records at all.

Coming from a single user environment I fell for the trap of marking records with an 'x' and it caused chaos in a multi user environment.

Daniele's method would be slightly better but would fall down immediately if two people had the same number of records in their individual found sets.

Either of the above will work fine in a single user set up but a global and multi line key is definitely the way to go

Phil