>Kevin,
>
> When useing the framework, how do you select records from more than one table and not get records that have been deleted in the resulting view.

Fred,

You should have an index on DELETED() and add a NOT DELETED() condition on your view

HTH

Rex