need sql help

[eluser]theprodigy[/eluser]
If I understand correctly what you're saying, I don't think it will work.

Take, for example, a credit card bill. Let's say my minimum due is $150. Bill comes in, I pay the $150. At the end of the month, I have extra money left over, so I pay an additional $200 to the credit card to try to pay it down some.
Bill comes in for $150.........doesn't show up on the list because my payments exceed my total due to company, but I still have that bill to pay.

Plus, in all actuality, I don't think my current table structure will work anyway. I need to have an Account table in between Companies and Bills. I have one company that I have several accounts with. I need some way of keeping those accounts separate, and don't want to hack it by saying they are different companies.

I'm open for any new table structures that may make this easier, or even pre-written software that I can use. It has to be web-based or at least use the internet protocol. Right now, me and my GF are in different locations (different states), and we both need to be able to read / edit the records.