Hi,

I currently have my tables set up as Directory , DirectoryCategory, Category, CategoryEntry & Entry.

I can grab all entries in a category and apply sorting etc.

But now I am looking to pull all entries that belong to a certain directory and filter those results by 2 Fields (is the entry active, has it not expired, and it's alphakey e.g. a).

I then wish to do the sorting by name.

I can do the filtering by keys and sorting but I don't know how I could build the relation between the Entry Table and Directory Table. Could you please shed some light please.

I've looked at the help where you show how to filter based on another table but this involves three tables doesn't it? DirectoryCategory, CategoryEntry and then Entry?

Many Thanks,

John

The Northwind example project has a form 'customers per product', which spans 4 tables if I'm not mistaken.

You could peak into that sourcecode and check if that makes sense. If not, please enlist here what the relations are between your objects so I can help you formulate the relation collection and predicate expression.