> > I have table1 related many-to-many with table2, using table3, containing > the keys of table1 and table2 and related one-to-many with each. Table2 is > also related one-to-many with its child table4. I have a form used to > navigate and add to table1. When I add to table1, I relate the new record > to table2 by adding several records to table3. At this time, I can > generate a new record in table4 for each record in table2 which is related > to my new record in table1. So far, so good. > > Now I'd like to add a grid which displays all the records in table4 which > are children of the records in table2 related to the current record in > table1. This grid needs to display one or two fields from table2 (not the > key field) so that the table4 records can be easily identified. If I need > two adjacent grids to display those fields, that's OK. > > This app was designed for standalone use and has no views. That may change > in the future. The main purpose of this form is navigation, so it can't > afford to spend much time querying. Yup, sounds like you need two grids. The grid on the left has the Table4 and Table2 records, and the Grid on the right has the Table1 records. The relationship should be set from Table4 to Table2, Table2 to Table3, and Tabel3 to Table1. Thus the Grid on the right only displays the Table1 records that correspond to the Table2 record on the right side of the Grid on the Left Grid. Got it?