URGENT: Data Lookup

[StacyStacy]

HELP!
How do I create a combo box that looks up a location based on another combo box in the same form that shows the Provider name?

Example:

The first combo box allows you to select the Provider ID. In this instance, the Provider ID = 506. The Provider ID, "506" represents Hinds Community College.

Now, Hinds Community College has 6 locations (1 in a different city). the city of Raymond = 0. The city of Jackson = 1. The city of Utica = 3, etc.

In the second combo box, I want to select the location of the Provider ID --> 506. (I want to see a list showing the Location ID associated with the Provider Id 506, which is: "0", "1", "2" and "3" etc.

How do I do this? Please help. I need to deliver this application 1st thing in the morning.

 

[Jack Cowley]

You will find your answer here.

hth,
Jack

 

[StacyStacy]

I still need some assistance. Would someone be willing to give me a call or if it is long distance, I am willing to call you. Just let me know and send a private message .
Thanks

 

[GetReel]

Ok! heres a sample of what you are trying to acheive!.

I have plenty of other sample if u need any but Im sure if you look up cascading, you will find heaps of sample on this forum

Jack has given you a good starting reference point.

 

[StacyStacy]

Thanks,
But I am able to create what your examples are doing. I need to select a value from a combo box that will prompt me to select another value. From the last value that I will select, I will populate other fields with data relating to the second combo box value.