Hi Folks. Me again.
I'm still working on the same database. I now have tables related one to many and have finally developed a dataentry form that will work. Now, onto the reports. These tables collect data off an online form. tblFumigation has one entry per field for each report entered. tblCommodity may have several entries for each report. For example, tblFumigation has a record with primary key 27. tblCommodity has three records with primary key 27. When I do a report, I find that the query between these two tables repeats all the info for record 27 three times. So, when I try sum one of the fields for record 27, I get erroneous sums because the value I'm interested in is repeated three times in the dynaset produced. Any ideas for help with this??
I'm still working on the same database. I now have tables related one to many and have finally developed a dataentry form that will work. Now, onto the reports. These tables collect data off an online form. tblFumigation has one entry per field for each report entered. tblCommodity may have several entries for each report. For example, tblFumigation has a record with primary key 27. tblCommodity has three records with primary key 27. When I do a report, I find that the query between these two tables repeats all the info for record 27 three times. So, when I try sum one of the fields for record 27, I get erroneous sums because the value I'm interested in is repeated three times in the dynaset produced. Any ideas for help with this??
