look up tables

[DAS120202]

Hi,
I am a little new at access, so I am having quite a few problems. The main one that I would like to solve is look up tables. I have been trying to create a look up table that will pull down and then insert all of the information in that table.
An example would be that I scroll in the look up table to the correct style number that I want. Then not only does that field fill,but the item description, size, cost and price fields are also filled with the corresponding info. Any advice would be a big help.
Thanks,
Ruth

 

[jfgambit]

Ruth:

Are you trying to do this in a Form or in the Table itself? From your explanation it sounds as if you already have a table with all the necessary information and what you want is a Combobox on a form that will Lookup the information once you have selected or entered the style number.

Am I correct in this assumption?

 

[DAS120202]

I appreciate both of your replies. I am still a little confused though. I have been reading up on both combo boxes and the autolookup query, and I am still unsure of what I should do. In more detail I am trying to make a look up table to use in a form.
Example: I have a Products table. In that table I have the style#, description, size, cost, price, ect. I want to be able to then go into my orders form to create an order. In this form I will have an order #, flag, customer name, and then the product info. What I would like to do is look up the style number of the product, and then its description, size, cost, price, ect is automatically filled in once the style number is picked.
I really appreciate your help. This is the first data base that I have worked with in access. So I am trying to learn as I go.
Thanks,
Ruth