Hi Bonnie,
This is how I approached the same task in VFP; loading the entire list of Buildings into a cursor and then filter it based on the user selection of Site. I will try to find an article on the web teaching how to filter DataView. I am jumping from .NET to VFP all the time and not very much up on how to do things in .NET.
Thank very much for your suggestion.
>I'd also use a DataView of your Buildings DataTable instead of the DataTable itself for you Buildings drop-down, that way it's easy to filter it in the Site drop-down's event handler.
>
>~~Bonnie
>
>
>
>
>
>>Hi,
>>
>>I have a drop-down list of Buildings on a web page. Currently a dataset of buildings is created in the PAGE_LOAD method. Then (still in the PAGE_LOAD) the drop-down list is bound to the dataset.
>>
>>Now I need to add a Site drop-down list and in the Building drop-down list view only buildings that belong to a site (after user selects a site). Building table has SITE_NO field so that based on the user selection of Site drop-down I can determine which buildings to retrieve from the Buildings table. My question is what method should I use to create a dataset of buildings and bind it to the Building drop-down? I suppose this should be done in one of the methods of the Site drop-down, right? Which one?
>>
>>Any suggestions would be greatly appreciated.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham