This topic is locked
[SOLVED]

 Apply where clause to DDL at runtime?

10/5/2017 3:05:47 PM
ASPRunner.NET General questions
Pete K author

Here is my situation. I have a dropdown list of schools populated from a table using a Lookup Wizard. At runtime, I want to apply a dynamic where clause to that table such that only Elementary or Secondary schools are populated into the list, based on the value of another field in the record being edited. Is this possible? Any implementation ideas?

jadachDevClub member 10/5/2017

Can you not use dependent dropdowns? Is the other field that dictates the filter a text field?

admin 10/6/2017

Either dependent dropdown or use SQL variables in WHERE clause of lookup wizard.

Pete K author 10/9/2017

Dependent dropdown -- that's what I was looking for. Thanks to you both.