Brian,

I think you'll find life easier after looking at parameterized views. There is an article over on my website that shows comparisons between grids using linkmaster etc vs using a p-view to do the same thing. It's under Q&A, Forms, qFRM002

>I have a Parent - Child - Grandchild table structure. Table1 is the parent, Table2 is the Child, Table3 is the Grandchild. I have a relation between Table1 and Table2 (SET RELATION TO table1_key INTO table2 IN table1). There is a grid on my form that displays Table3 and has all of the appropriate properties set up correctly (childorder, linkmaster, etc.) to make Table3 a child of Table2. However, the grid will not display only the records appropriate for Table2. If, after running the form, I select table2 and browse it, the grid updates and now displays the correct records. If I remove Table1 from the mix and make Table2 my top level table, the grid works correctly. If I make the grid display the info for Table2 instead of Table3, it works correctly. The only time I can't get it to display correctly is when all three tables are involved. I have even opened all tables from the command window and manually set the relations, and browsed the tables, and everything is fine (move
>the record pointer in Table1 and Tables 2 and 3 update correctly).