My portal is displaying all records when I want just the found set to appear. Any suggestions?

Thanks.

L.

Hi Leonard,

the portal overrides any found set and gives you the scope on the entire set of related records.

You can switch to an appropriate list-layout in which you can display the found set.

There are tricks to force portals but are hard to apply.

Greetings.

[ June 07, 2001: Message edited by: JPaul ]

I'm having the same problem because my relationship uses Match fields. When I look in my related file it found the records with no problem. But how to create a relationship between my current file and the found records file is the problem. I wrote a script that uses the Replace command to set a 1 in a "FoundRecords" field but that takes way too long. If there was a Status function that allowed you to mark found files with a 1 you could setup the relationship between those two fields(calculated status field :: Match field).

This will take several steps. Ultimately you want your matchfield for the found set to be the same as the matchfield for file in which the portal is found.

Step1. In the master file, execute a external script that will perform the search in the related file,, then Replace the MatchField with X (whatevery your current uniqu ID is) &" found". This will change the field data in all the found records

Step 2. in the master file, change the match field for the portal to the same as you did above for the related file.

The replace comand is a little slow esp if the found set is large.

In smuumary...

perform subscript (external related file) xyz (in related file:to find and replace and exit script)

Setfield (MFMasterfile, MF & " found")

Hope this helps

This will take several steps. Ultimately you want your matchfield for the found set to be the same as the matchfield for file in which the portal is found.

Step1. In the master file, execute a external script that will perform the search in the related file,, then Replace the MatchField with X (whatevery your current uniqu ID is) &" found". This will change the field data in all the found records

Step 2. in the master file, change the match field for the portal to the same as you did above for the related file.

The replace comand is a little slow esp if the found set is large.

In smuumary...

perform subscript (external related file) xyz (in related file:to find and replace and exit script)

Setfield (MFMasterfile, MF & " found")

Hope this helps

Greg