HELP!!!

Topic

New Reply

I’m trying to combine a bunch of tables that show all account activity (invoices, payments, withdrawals, etc.). It is a database that keeps track of students school fees. The problem is that on the invoice I have several lines because they have several different fees to pay. But when I try to show a payment, it doubles it up. On the invoice screen there is a payment button that you click on to go to payments and enter the invoice that it is paying which in some cases might be only partial payment.

So I had an Elementary fee for $35 and a Student Council fee for $5, then the student made a payment of $30. But when I try to put them together, it puts the $30 payment on each invoice line, so it comes out as a $60 total payment.

I need HELP!!!

Reply | Quote

Replies

if you will post the code we might can help

Reply | Quote

Okay…I’ll explain what’s going on. I have a student form that shows the student’s name, parents, address. On that form I have a button that opens an Invoices form. On that form I have a button that opens a Payments form, and a button that opens a Withdrew form. Now…

I made a button that opens an Account form. That form I made from a query that queries all the tables together. When you look at what info the query pulls, it shows each line of the invoice with the SAME $30 payment next to it. I want the program to tell that there was only one payment and not list it on each line of the query. How do I do that? Am I missing a step?

I hope you can tell what I’m trying to explain. I don’t really have any code to show you because it is the query where I think the problem is.

Jennifer

Reply | Quote

A good place to start looking is your table relationships.

If you do not have the relationships between tables properly defined, that might give you that repeat value of $30 for each entry. The first thing to note is how many records that query generates. If the number seems ludicrous you more than likely have those set incorrectly.

jazguessin’

Reply | Quote

I have a separate table for payments. I have a Student table, Invoice table, Invoice Detail table, and a payment table. I have joined the Payment table to the Invoice table by way of One-to-many (Invoice table to Payment table). Is this maybe the problem?

Jen

Reply | Quote