Association and Autofill Help

[LamJam20]

I will try to explain as easy as possible. I am new to Access and currently using it to track merchandise provided by brand.



I have two table currently setup:
1 - Manufacturer Information
2 - Inventory

I also have 2 forms:
1 - Add Manufactuer
2 - Add Inventory

The Inventory form allows me to select a Manufacturer and then add it with a specific inventory piece. I have it setup where it is associating the manufacturer's name but I need it to also pull the telephone number and additional company info from the minute I select the manufacturer's name. However, what is currently happening is I select the name and it doesn't autofill (let's say telephone) but rather gives me all the telephone numbers of all the manufacturer's in the Manufacturer Information table.

So i need to find a way to autofill a cell (in forms) when another cell is changed.

Does that make sense? If so, please help.

[pbaldy]

Does this help:

http://www.baldyweb.com/Autofill.htm

[June7]

Not sure what you mean by "gives me all the telephone numbers" - gives you where?

Select manufacturer from a multi-column combobox. Combobox RowSource has columns for other manufacturer info. Expressions in textboxes reference combobox columns by index, index begins with 0: =cbxMftr.Column(2)

Are you saving manufacturer ID into Inventory?

And now I see Paul's reply which is the same suggestion.