A third table (Involvement) is the intersection table storing Customer ID and Project ID as foreign keys.
I need to select Project.* given Customer.[Customer Name].
So far my query is
Expand|Select|Wrap|Line Numbers
- SELECT Project.*
- FROM Project INNER JOIN (Customer INNER JOIN Involvement ON (Customer.[Customer ID] = Involvement.[Customer ID]) AND (Customer.[Customer ID] = Involvement.[Customer ID])) ON (Project.[Project ID] = Involvement.[Project ID]) AND (Project.[Project ID] = Involvement.[Project ID])
- WHERE (((Customer.[Company Name]) Like "*" & [Forms]![Customer-Project]![Company Name] & "*"));
I have to implement the same in a form of the Project Table, but I got stuck on the filter part, because it can only take a WHERE clause.
How do I make the inner joins work on a form filter that is on a different table?