Hello all.
I am trying to create a dynaset against a dynaset. Because of performance problems within my database project, i am wanting to use the first dynaset that populates a list box to narrow the search items for the second dynaset. Right now, I am requering the entire database when validating the selected item, which is very very slow because the SQL "WHERE" criteria is very large. Hopefully narrowing the search to the items that are only available in the listbox will speed up the validation (it is important to note that the user can either select the items in the list box or they can enter the product number in a text box...) Anyone know if I can do this or are there any other ways that are better that a "green horn" can understand?
thanks in advance,
JDL
I am trying to create a dynaset against a dynaset. Because of performance problems within my database project, i am wanting to use the first dynaset that populates a list box to narrow the search items for the second dynaset. Right now, I am requering the entire database when validating the selected item, which is very very slow because the SQL "WHERE" criteria is very large. Hopefully narrowing the search to the items that are only available in the listbox will speed up the validation (it is important to note that the user can either select the items in the list box or they can enter the product number in a text box...) Anyone know if I can do this or are there any other ways that are better that a "green horn" can understand?
thanks in advance,
JDL
