Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 109
  • Last Modified:

Table/Query or Value List field lookup whose content depend on another field's content. How-to?

Hi,

I'm trying to design an Access table in which a field named "Choice" would present, in datasheet view, a dropdown list whose possible values would depend on another field named "Category".

For example, say a record would have " Category='Color' ", then field "Choice" might present a dropdown list with 3 possible choices : "Red", "Green", and "Yellow". However, if it would be " Category='Fruit' " the dropdown list would show 2 possible choices : "Apple" and "Orange".

In other words, the value of the "Category" field would determine the available options in the "Choice" dropdown.

How can I do that?

Thanks,

Jean
0
J2015
Asked:
J2015
1 Solution
 
bfuchsCommented:
create a table with two columns category and choice, there you enter all possible choices for each category, then in selection have two drop downs, one with all categories and the second should have all choices where category = formname. firstcombo.
in the after update event of first combo write combo2.requery.
0
 
PatHartmanCommented:
This is not possible in a table or query.  Cascading combos depends on event processing so you can only do this in a report or form.
0
 
J2015Author Commented:
That's what I thought. I just wanted to be sure.

Thanks.

jean
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now