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.

Thank you.