I have a tblStores with 1toM relationahip with tblProjects. User selects a store using a form and then views various projects in that store. It works fine except for the fact that occassionally I see a duplicate record of the same store/project (no duplication in tables though) . When I investigated this issue, I realised that in my main form (linked to tblStores), in order to give users view of only those stores where associated projects had active status, I joined tblStore with tblProjects and applied the criteria based on a field in tblProjects. This inevitably resulted in producing two or more store ids wherever I had more than one project with active status. I think this occurance at the main form level resulted in two or more instances of stores and its projects appearing more than once in the sub form.

My question is, how could I restrict my stores based on a field in the many side without adding tblProjects to the query when calling stores and associated projects.

visuals would help here.

Thanks Adam. By hiding the project status fielsd in the many table, grouping the query and choosing to see unique values only, I managed to restrict my records. Much appreciate looking at this.