The WHERE clause also refers only to the main table in the form. But SQL can do anything! Assuming there is a column that is a primary key in table 1 and it is repeated as a foreign key in table 2:
EDIT USING formname WHERE t1.linkingcolumn IN (SELECT t2.linkingcolumn FROM lowerLevelTable t2 WHERE clause ) However, you may see rows in the secondary table of the form that do not match your WHERE clause, since there may be other rows in T2 that are related to the rows in T1 that are found with your sub-query. (Clear as mud, right?) IF you really need to see only a subset of T1's matching rows in your form, there are many other ways to get there. For example: Don't make it a two-table form. Instead of the second table, put a variable lookup listview or variable lookup listbox, and use the EEPS associated with that control to bring up an editing form for any row that is clicked on. Bill On Tue, Jan 13, 2009 at 2:53 PM, Dan Goldberg <[email protected]> wrote: > I am drawing a blank. > > I have a form with two tables and would like to do a where clause on the > lower level tables. > > I tried: > > T1 - master table > T2 - lower level table > > Edit using formname where T2.columnname = 'clause' > > But it does not work. How do you filter the lower level tables results?? > > TIA > > Dan Goldberg > > > > >
