Exact searches. First post incomplete

[wwyngaard]

I have read many of the posting about -LOP and -Op and am trying to use == instead of operators. My problem is I have a search page with 2 fields Item number and part number that I want to search and get an exact match on 1 or the other field. In other words if you search for part number 33 I don't want it returning 33 and 334. If I add the code to make the fields exact and someone searches on one field it only returns records that have the exact match of 1 field and an exact match of nothing in the other field. It seems to do a strict enforcement of the default AND Logical operator. If I add the OR operator it returns anything with an empty field also.

Is there a way to get an exact match of 1 field if both fields are specified to be exact?

Thanks,

In advance.

Wayne

[Keith M. Davie]

"Is there a way to get an exact match of 1 field if both fields are specified to be exact?"

You might try setting up two form actions and providing two buttons. If your user knows the Part No. they enter that and click that button, if they know the Item No. they enter that and use that button. Of course, you will want to use the exact search criteria in each form action.

SIMPLIFY ...

Keith M. Davie

[wwyngaard]

Thats a good idea. Use 2 forms actions on the same page.

Thanks,