Payments and Running Total

[cathalfarrell]

Hi Everyone,

I'm quite new to access and a bit of a newbie when it comes to databases in general so your help is greatly appreciated.

I work in Medical Tourism and I am designing a database to collected enquires, bookings and payments and then automate the invoice.

I have numerous tables but essientially three: enquiries, bookings and payments.

A customer can make a number of installments prior to the surgery as long as the final balance is paid on the day. The total amount for the surgery is held in the bookings table.

I would like help with two things that I think are related:

• To make a payment I would like a form with a combo box that will allow me to select a customer name and apply a payment to it. This will require the name from the enquiries table, that have they made a booking, and there is a balance on the account. Not sure if I've explained that very well so please ask for clarifiaction if needed.
• Also I wold like to be able to print a report(invoice) for a customer that will display all payments and the remaining balance.

Any help you can give with these would be great.

Thanks
Cathal

 

[jzwp22]

Can you show how the three tables: enquiries, bookings and payments are related to one another?

How are payments applied if a customer has many bookings?