It sounds like you are getting the cross product of the two tables. That happens if you don't provide join criteria. With the report open, check the Visual Linking Expert in the Database menu. The two tables should appear with an arrow connecting the two. If the arrow is not there, you'll need to add a link (click and drag between related fields). If the arrow is there, double-click it and check the join.