Creating Multiple Dependant User Options

[s.carter]

Hi, I'm very new to access. I've created only one (pretty sweet) database. Now I'm working on my second. I have 5 tables. 4 have a list of info:
Fruit - Apples, Tomatoes
Color - Red, Yellow, Orange
Action - Eat raw, make salad, toss
Note - note1, note2, note3

The fifth table has relationships with the first 4 tables:
Apple | Red | Eat raw | note1
Apple | Yellow | Eat raw | note2
Tomato | Red| Eat raw | note2
Tomato | Yellow | make salad | note3
Tomato | Orange | toss | note1

Next I created a form with a combo box to choose the fruit. I made this a unique value because I don't want the user to see 2 Apple choices and 3 Tomato choices.

The user needs to select Apple or Tomato. If the user chooses Apple the form should present the options of Red or Yellow allowing the user to choose. On my form, it only shows Red (I guess because that's the first choice).

How do I create a form that has a combo box to choose a fruit, then radio buttons listed with all the color options, then depending on what the user picks for these first two items will display the proper action and note?

Thanks

[orange]

The subject you are describing is called Cascading comboboxes.
There are 2 excellent videos from Datapig to help with the concept.
These were done in Access 2003, but the concepts are relevant to all versions.

Your Note table should not have fields Note1, Note2. You should review normalization.
What do the Notes refer to. You need some means to relate each Note to a specific topic.

http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

[s.carter]

Perfect. Thank you!

[orange]

You are welcome.
There are several free videos at Datapig.