Hours one to many relationship to Quantity/Complexity

[Jake94]

I have an issue pulling data. Hours table with a 1 to many relationship to Quantity/Complexity table. The entry on the form is a hours entry then up to 4 Quantity/Complexity entries. So, on the table i.e. there is 6 hours on the hours table and 10 Complexity 1, 20 Complexity 2, 30 Complexity 3, and 40 Complexity 4 on the Quantities/Complexity table. When I pull a simple query the 6 hours is listed with each complexity.

Hours Quantity Complexity
6 10 1
6 20 2
6 30 3
6 40 4

If you sum it up this entry appears to be 24 hours not 6 hours. How can I resolve???

Thanks for your help!!!

 

[boblarson]

This is a one-to-many situation and should be shown using a main form/report for the hours and a subform/subreport for the rest. The mainform/report would have one query for just the hours and the subform/subreport would be another separate query and then the Master/Child links would be hours.