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