I have a form that displays information from 3 differnt tables. A Project Table, an Instruments Table, and a Hardware Table. The pupose of this form is to track the instruments and hardware deployed for a particular project. So what I did, was i displayed the project information on the initial form and placed two subforms (instruments, & Hardware) within this form. The problem I am having is trying to print the report that shows the information for each project (Instruments and Hardware at each site). When I create a report it basically multiplys the hardware X the Instruments and displays for instance 3 X 4 = 12 items instead of only 7 items. It displays each instument before each hardware item.
I was wondering if anyone had any suggestions as to how to go about fixing this problem? By the way all tables are linked by the project ID.
I was wondering if anyone had any suggestions as to how to go about fixing this problem? By the way all tables are linked by the project ID.
