03-09-2010 03:00 PM
The match record function in the Network Client of 7.5.2 matches Leads to Contacts and Accounts on multiple fields using AND. I'd like to change that to OR so it can find potential matches with a less strict query. I think below is the pertinent code from that form, I'm not certain where these change can be made in the Script for that form. I don't see where it gives the user the opportunity in the form to change AND to OR. You can select which values to search on, but they all seem to be joined with AND.
Thanks for any help
==========================
Function GetMatchCaption(ByVal MenuItem)
Dim strOr
Dim strAnd
Dim strValue
strOr = Localize("OR")
strAnd = Localize("AND")
GetMatchCaption = MenuItem.Caption
If (MenuItem.ImageIndex >= 0) And (MenuItem.ImageIndex <= 9) Then
If chkAndOr.Checked And MenuItem.Checked Then
If IsWinXP Then
strValue = Chr(9) & Chr(9) & Chr(9) & strAnd
Else
strValue = " " & strAnd
End If
GetMatchCaption = arrCaptions(MenuItem.ImageIndex) & strValue
Else
If (Not chkAndOr.Checked) And MenuItem.Checked Then
If IsWinXP Then
strValue = Chr(9) & Chr(9) & Chr(9) & strOr
Else
strValue = " " & strOr
End If
GetMatchCaption = arrCaptions(MenuItem.ImageIndex) & strValue
Else
GetMatchCaption = arrCaptions(MenuItem.ImageIndex)
End If
End If
End If
End Function
Solved! Go to Solution.
03-09-2010 04:06 PM
Unchecking "Match Select Items" changes the ANDs to ORs.
03-09-2010 04:11 PM
Doh!
Thanks. I would have seen that.