Hi...

Is there a code where you will create a new table with fields in Microsoft Access 2003?

I have a problem with my project. My project is all about Video Rentals and I made a database using ADO Data Control. In my project, there is a customer's info where he/she will fill out the form. And then there is a listbox where you can see his/her rented videos. That's my problem!

Since there are different user, there are also different rented videos by each of one of them. I made a table for the customer's info. But I didn't include the rented videos because of that problem.

If you click on the next button, another list of videos from that user will appear. And when you click again, a different rented videos will again appear and so on and so forth.

Can you guys give me an advice on solving that matter? Thanks!