Steve,

I'd use a parameterized views on the two child tables. As you navigate rows in the parent table simply Requery( "ChildView" ) for each pview and refresh its grid.

>I have a table with unique job numbers. I have two other tables that hold the scope of work for these job numbers. Thes tables represent departments with fields to hold dates, hours and resources. I have one form that displays the job number and two grids each representing departments displaying the schedule of work. I have these grids linked to the main table. When I scroll the main table I get an error that "Target Table is already engaged in a relation. Is there another way to do this? Or can I fix what I have an avoid the error?