>I have a parent table P2 and two related child tables C1 and C2.
>Each table has in excess of 1 million records. After SETting
>the RELATIONs, how can I examine only those records in the
>children tables that should be constrained to the parent relationship?
>
>Based on the child related info, I will update a field in the
>parent table.
Create a form with 3 grids. Set recordsources as P2, C1 and C2. In C* set linkmaster, childorder, relationalexpression. You're done.
Cetin