URGENT: Data Lookup

StacyStacy

A "Californian" at heart!
Local time
Today, 16:18
Joined
Jan 29, 2003
Messages
159
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.
 
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
 
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.
 

Attachments

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.
 

Users who are viewing this thread

Back
Top Bottom