Lookup Wizard Help

[bonnepoutine]

Hi guys!



First off I'm a mega Newb. So this might be a stupid question but I'm still stuck.

I have created a form in which the users will choose from a pre-determined list. Ex: North, South, East or West.

I also have a data table which has info for each of those options. For Example:

North | Blue | Red | Green
South | Black | White | Pink
East | Blue | White | Red
West | Purple | Red | Grey

So in the form I want a user to be able to choose 'North'' from a list (which I have done with the lookup wizard)
But once they choose ''North'' I want the options in the next field to be limited to ''Blue, Red or Green'' if they choose ''South'' then they should only be able to choose ''Black, White or Pink''

Any help on how this can be done explained in the simplest terms possible would be super appreciated.

Thank you!

[June7]

This is called cascading (or dependent) combobox. Topic of many, many, many discussions. Search forum and web for examples.