Can't get orders to show invoices from different tables!

C

Crispywafers

How would I get a form that shows all orders that a specific student
has placed (like in a datasheet list). Then when you click on a
specific order it shows all invoices tied to that order ID (once again
in like a datasheet list). Then when you click on a specific invoice…
it shows all payments associated with that Invoice ID (datasheet
list).

I just basically cant' figure out how to do this when I have my
Invoices split into three different tables instead of one Invoices
table. So Orders basically has three tables tying to it (with OrderID)
and I want it to show a list of every Invoice in July, March, and Dec
tables with an OrderID = whatever for StudentID = whatever in a form.

I have the tables:

Student_Records (StudentID)
Orders (StudentID, OrderID)
July Invoices(OrderID, InvoiceID)
March Invoices(OrderID, InvoiceID)
Dec Invoices(OrderID, InvoiceID)
Payments (InvoiceID, PaymentID)


How can I do this? I seem to never be able to get anything more then
one invoice to show under a specific order—when I know there is 3!
They are just split in different tables!
 
Top