I have two tables in Access.
One table is of Projects, and the other table, is of components that belong to each project. The COMPONENTS table has a field Proj_ID which takes uses a drop down to the PROJECTS table as a lookup for the field.
I would like to write a query that will return the...