Hi!

I'm using Version 2.0.0.0 final, SelfServicing .Net 2.0 against a SQL Server 2000 DB (8.0).

I'm going to give a simplified version of my problem in hopes of making things a little easier.

I have a Customer table and an Orders table. Each Customer can have multiple orders. You can access the Order collection like so:

Customer.Orders;

Now the Order table has a flag called "Active" which basically means the same thing as deleted. I want to insure that when I call "Customer.Orders" I never get an order record with the active flag turned off. Essentially I want to insure that the following predicate:

OrderFields.Active == true;

is attached to each call to Customer.Orders;

I hope that's clear, and that there is a solutions

Please check the following similar questions: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=8999 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=5753