Good Morning,



This is one of my first times working in access, and I have to create a video rental database for a class. So far, I've created three tables - customers, movies, and rentals. I need to be able to create a form that will start a new transaction. I need to select an existing customer from the database, see if they have any movies out at the time (and if they are overdue), and allow them to check out new movies.

I'm not asking for my homework to be done for me, just some guidance on how I even go about pulling this information together correctly!

Thanks for any help!!

-Nellicious