setting up my form

[Mr. Nice Guy]

I have a Test request table, a Customer table, a Platform table (which is like a research program), and a Part Table (as well as a few others which were left out for simplicity's sake).

here is how the relationships should work:

One Customer can have many test requests, however each test request only has one customer (one-to-many)

One Customer has many Platforms, however each platform only belongs to one customer (one-to-many)

One Platform can have many different parts, and one part can be in many different platforms (many-to-many)

Now I would like to set up a form so that people can fill out test requests, and i'm having trouble going about it because of my complete noobishness . i would like the form to have a drop down displaying the current test number (Primary key of test request table) as a label, also a dropdown with all the available customers. beside that should be a dropdown so that the user can choose one of the customer's platforms (this changes depending on the customer), and perhaps another combo with each part from the selected platform. then the user should be able to fill in fields with test specific parameters which are saved to the test request field. how can i go about doing this? should i set up queries and what kind of queries. do i need VBA? or can i just use the tables? thanks for the help, this is a pretty basic question.

CB