I am trying to build a form for my virtual business. I rent virtual aircraft and what I want to be able to do is have a form that I type in a customer name and it pulls up in grid format all the entries about him. What aircraft he/she is renting payments made and payment date account notes the whole works.Here is my current table structures.

What I want is a form that I would type David Johnson in and in one grid it would give me all the information about the airplanes he is leasing in another grid it would give me all his payment information and in the third grid would be any attached notes that there might be.M I am thinking I will have to create a new table and manually populate the information for this, but there has to be a faster more efficient way.

Please remember I am brand new to database creation and am not familiar with all the lingo so if you help please explain as you would explain to a three-year-old. So that it is easy and simple to follow. A step by step process would be great. if you would like a copy of the database to see how i have it set up just shoot me a message and ill get you a copy. Any help is appreciated as I have been beating my head against this for about 4 hours with absolutely no progress./ I am wondering if I have to somehow set relationships or something for all this to work. its possible but alas I am completely unsure.