I was mucking about the other day and discovered that I could filter one table based on the contents of another table where there is a relationship defined between the two tables.
eg. SETFILTERTO othertable.status='I'IN mytable
By and large, I thought this was pretty neat but have not seen any documentation with respect to this feature.
=> Isthis a generally supported principal or just an undocumented feature???