Hello,
I thought this would be easy, but I can't get it to work.
I have 2 combo boxes and 4 tables. The main combo box, I'll call it Combo Box #1 drops down a list of 3 categories: grinders, candy and beer. 1 of my tables is called "ItemType" and it only contains the 3 fields - grinders, candy and beer. The other 3 tables are grinderTable, candyTable and beerTable. Each table lists different brands of grinders, candy or beer.
***All I want to do is this: When I select "candy" from Combo Box #1, I want the candy selection from the candyTable to appear in Combo Box #2. Likewise, if I select "Beer" from Combo Box #1, I then want to the Beer selection to appear in Combo Box #2. I have gotten similar db's to work when it's a 1 combo box item to one FIELD relationship, but I'm at a loss with this particular one. Any help is appreciated. I wish I could post the *.mdb file up here.
JL8

I have sent to your email address a small demo database created by Candace Tripp. I hope that this will help you solve your problem.