M
Martin Stabrey
My search form has 5 fields (all drop-down lists) that are all
empty/blank to start with ie. the first option of each list is
<option></option> in the HTML. The user can select data from any of the 5
fields. Some fields may be left unfilled when the form is submitted to the
DBRW.
I am using the And comparison for each field - so, as an example, if the
user chooses an option from list 1 and an option from list 4, I would like
only the records that match and are common to both lists returned for
viewing.
My problem is that the fields that are left untouched by the user are being
queried along with the filled fields (which is the way it should work )
I would like them to be ignored. Empty fields should not influence the query
at all.
How can I achieve this? Apologies for the nonDB speak. Quite raw at all of
this, but learning alot!
Mart
empty/blank to start with ie. the first option of each list is
<option></option> in the HTML. The user can select data from any of the 5
fields. Some fields may be left unfilled when the form is submitted to the
DBRW.
I am using the And comparison for each field - so, as an example, if the
user chooses an option from list 1 and an option from list 4, I would like
only the records that match and are common to both lists returned for
viewing.
My problem is that the fields that are left untouched by the user are being
queried along with the filled fields (which is the way it should work )
I would like them to be ignored. Empty fields should not influence the query
at all.
How can I achieve this? Apologies for the nonDB speak. Quite raw at all of
this, but learning alot!
Mart