How to create a ledger sheet

[studlength]

Hello. I have a database with the following tables:
Customers, Orders, and Payments
The Customers table has a one-to-many relationship with the Orders
table. The Customers table also has a one-to-many relationship with
the Payments table.
I am trying to create what I think is commonly called a ledger sheet.
This sheet simply shows the dollar amount of every order that an
individual customer has placed (debits) and every payment that the
customer has made (credits). It also shows a running balance. Entries
are shown in chronilogical order.
I am having trouble creating a report that would draw debits from the
Orders table and credits from the Payments table. I have had good luck
in the past using queries as sources for reports but I can't figure
this one out. I would like someone to tell me if I am structuring this
thing correctly and how to create the report I need. I would be happy
to supply any further info necessary. Thanks.

 

[Guest]

I'm not a guru as some here but I'll try.

you may need to check out what type of relationship you have in your query.
There's the deal with inner and outer joins that may help you understand how
to get orders without payments to show.

http://www.databasedev.co.uk/query_joins.html

Chris