In my current database, I have a single table which contains order
information such as product, unit price and payment. The payment for
each product is entered in and subtotals and totals are calculated
fields on reports. With this setup our customers pay for each product
in full.
I am trying to divide the table to move payment information to a
related table such that customers can make partial or installment
payments. I managed to divide the tables just fine but all of my
reports then began to show duplicated detail information. If a
customer ordered two products, then each of the products is listed two
time, (or three for three . . . )
When I delete the payment table from the query builder of the report,
the information doesn't repeat anymore, but of course I cannot send out
invoices without the info in the payment table. How do you stop the
repeating details in reports?
Thanks in advance for help.
Judy