Displaying Found Set in Portal

[Jarvis]

How do you get a portal on one layout to display the found set from another layout?

My portal holds 5 records. I would like this portal to only display records which have the STATUS FIELD set to "active".

Right now this portal shows the first five record from the other layout. It does not sort for the characteristic "active".

If anybody can tell me how to accomplish this I would be your most humble servant.

Jarvis

[Inky Phil]

H Jarvis

one method would be:

1/ create a global 'G_status' in the first file/table

2/ establish a relationship between the two files/tables based on G_status to status.

3/ set your portal to show records from this relationship

4/ Set G_Status to 'active'

the portal will then only show records from the second file/table where the status field = 'active'

HTH

Phil

[Jarvis]

Thanks Phil!

This was just what I was looking for.

Jarvis