On Thursday, April 07, 2011 07:44:56 am Henning Hraban Ramm wrote: > Am 2011-04-07 um 16:22 schrieb John Fabiani: > > Hi, > > I have always had issues with dropdowns selection determining the a > > second > > control. Now I have need to have fours dropdowns and each of the > > dropdowns > > data (or Choices) will depend on the preceding dropdown selection. > > Does > > anyone have a suggestion on how best to deal with my requirement? > > I reload the other dropdowns’ choices after a Hit on one, it all > happens in the onHit handler. > Perhaps I don’t undersa´tand your question? > > > Greetlings from Lake Constance! > Hraban > --- > http://www.fiee.net > https://www.cacert.org (I'm an assurer)
No that's right - I will be using OnHit. But the problem is not as straight forward as you suggest. If I set the first dropdown the second, third, and forth must match. If I set the second the third and forth data choices must match what is in 1 and 2 - and so on. If I set all of them and then change the first then all the rest must change. To make matters worse none of the data items come from the same tables. Each dropdown filters the data available for the next. And remember I want this to work with Dabo's DataSource and DataFields when not entering data into a new record. I have considered creating a view and then actually filter the data as required since the records are related but then I could have several thousands of records in memory. So I have discounted that solution. I have considered creating a class that would provide a dynamic property that could be set to retrieve the data (choices and keys). Similar to the ones Ed and Paul have created for other controls. Not sure how much work this would be? I have considered creating a single method that all dropdowns call and control the data in the method. I would be able to read the values (keys) from each of the controls and do what is required to reset the choices for each of the controls. This might be the way to go. But I looking for suggestions - from the list. I don't want to start a lot coding only to later discover I'm traveling along the wrong path. Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
