Lookup Help

[extremeshannon]

Hello,
I am just getting back into creating a Database with MS Access. I am trying to display products from a manufacture based on the manufacture field. I only want products that correspond to the manufacturer that is choose.

TBL Manufacture
ID
Manufacture

TBL Product
ID
ManID
Product

I am looking to have a combo box to select the manufacture and the next combo box only show the products from that manufacture.

I hope I have explained what I am trying to achieve.

Thanks for any help

Shannon

 

[theDBguy]

Hi Shannon. Welcome to AWF!


What you are referring to is called a "Cascading Combobox." If you search for that term, you should find a few tutorials or videos on how to create it. If you run into any issues, please let us know.

 

[extremeshannon]

Wow thanks for the fast response and thanks for the info I needed. i will look for that now.

 

[theDBguy]

Wow thanks for the fast response and thanks for the info I needed. i will look for that now.

Hi. You're welcome. Please let us know if you don't find anything useful. Good luck!

 

[isladogs]

Here's one fairly complex example of 5 cascading combos you might find useful
https://www.access-programmers.co.uk/forums/showthread.php?t=302126

 

[extremeshannon]

Thanks for the help. I have it working. Only 1 thing I am trying to get it todo now.

When i select a new Manufacture I would like the Product field to clear. Right now it stays with the last item that was displayed and it is not correct product for the manufacture.

Thanks Shannon

 

[MajP]

In the after update of the combo manufacturer reset the combo product
me.comboProduct = ""

 

[extremeshannon]

Thanks that worked great.

 

[extremeshannon]

Hello Folks.
I have been working on a Cascading ComboBox for the entire day. I still have not got it to work. I am posting a Shell of my DB not any info in it really.

I am working on frmLoftRecord ComboBox Rig Name.

I want to only show Rig Names of the customer that is chosen (cboOwner)

I think the relationships are correct. Any help pointing me in the right direction would be great. I have set up some cascading Combo Boxes on frmRig and they work. The Database is under construction and there is a lot to be done and cleaned up.

Any other suggestions about my DB design or better ways to do it would be appreciated.

Thanks for all the help so far.

Shannon

 

[JHB]

Where is the control with the name [cboOwner] in the form?

 

[extremeshannon]

From the top left over to right one and down one. It is bound to CustomerID

Shannon

 

[JHB]

Is it so you want it?

 

[extremeshannon]

Is it so you want it?

Thanks this will do the trick.

Shannon