Hi Guys,

What i would like to do is provide a filtered set of data via a group of two table occurrences based on the same base table (ie. a self join)

Let's say i have a products table that contains absolutely all the products that have ever passed through my company and in that table i have a boolean field which marks the products that are currently active. There is also a global which contains the number '1'.

I then join the two TOs via the global field and the active products field. This way i hope to filter the resulting products list to show only those products which are currently active.

Now comes the big question... I know i can achieve this list by having a layout referencing on one of the TOs and a portal in that layout referencing the other TO.

What i want to do is achieve the same result without have to use a portal! Ie. the TOs are in essence a saved query and i then only have to display the contents of one of the TOs which supposedly have already had their contents filtered in the relationship graph. My reason being, i find portals to be a very restrictive way of displaying the data. It would be nice to be able to manipulate a bit more the layout, switch between form, list and table views, etc. and still have the filtered data available to me without needing a portal.

Is this even possible?

Thanks for the clarification!

Andy.

Layouts and TO's do not filter records - only relationships and finds do. See also:

http://www.fmforums.com/forum/showpost.php?post/296774/