filtered portal problem

[The Gardener]

In a file called Journal, I have a 'Journal' table and data entry layout on which I have three text fields which I will call category, subcategory and subsubcategory. Using a file found here at fmforums entitled Conditional Value List_4, I constructed a three level conditional value list setup for these three text fields. The actual data referenced by the three value lists reside in another file, 'Setup'. 'Journal is related to 'Setup' by two table occurences, see attached picture.

On the same data entry layout I would like to have a self related portal through which one could view, ideally, other records from the same subsubcategory, or even a multi filter of three globals if necessary to make it work, category, subcategory and subsubcategory.

I have to admit that my grasp of fm.7 is sorely limited at this point.

I have tried so many ideas that I am confused. I did at one point think I had it working only to discover that as my portal globals used the same value lists as the data entry text fields changing one changed both [ie. change a text field and the global changed also].

Do I need to setup a parallel system for this conditional value list 'system' to use to filter the portal or is there an easier way?

Help appreciated.

[comment]

as my portal globals used the same value lists as the data entry text fields changing one changed both

That may have happened, but not for the reason you mention. A value list is merely a device to enter specific values into a field (and to display them). You can have two or more fields share the same value list, just as you can have two or more instances of the same field with different value lists (or none) attached to them.

To view other records from the same subsubcategory, define a self-join relationship:

yourtable::subsubcategory = yourtable 2::subsubcategory

[The Gardener]

Comment,

Thanks for the help. Works of course. So apparent when considered, and more so on a new day with a clear mind.