New database question--HELP!!!

[apugh1971]

I have a database with two tables. I am trying to create a type of items check out database. In one table are my videos. The other table contains everyone who can check out the videos. I would like a form to display, where I can choose a video, then an account number and then the account number holder's information would appear. I think this is probably easy, but I just can get a handle on how to create. If anyone can help I would appreciate it. Also, if there is a sample database like this somewhere, please let me know how to find it.

 

[RuralGuy]

Have you looked at the NorthWind sample db that comes with Access?

 

[Ron_dK]

Or check Inventory control , which is one of the templates that comes with Access.