Hello Everybody,

This is with reference to Lookups in SalesLogix 7.5.4.

For some lookups it shows below three checkboxes 

• Create a temporary group containing all results


• Case Sensitive Lookup


• Within current Group/Lookup

But for some lookups only last two checkboxes.

It was found in Tools->Options->General Settings to set last two options.

But option for first one is not there..

Any suggestions?

Appreciating your efforts in advance.

With Best Regards,

Pankaj

This will depend on how the lookup is called. If you are using the standard functions - check the Acc/Con Detail and notice that it's called with

                   strLookup = "Account:Subtype"  'DNL
                   blnUseFunction = False

This is how you get 3rd option.

Hi,

I am using brelow code:

Sub NewLookupClick(Sender)

    On Error Resume Next
Dim strLookup
Dim blnUseFunction

strLookup = ""
blnUseFunction = False

strLookup = "GC_ACCOUNT_Z:DataPool:DataPool"

If strLookup <> "" Then
If blnUseFunction Then
Application.BasicFunctions.DoInvoke  "Function", "Lookup:" & strLookup  'DNL
Else
Application.BasicFunctions.DoInvoke "Lookup", strLookup 'DNL
End If
ErrorCheck Application.Translator.Localize("Error accessing SalesLogix VBScript functions:")
End If 'if strLookup <> ""
End Sub

It is not rasing any error, but how could I get result (ID)?

Also how could I recognise group creation?

Appreciating your efforts,

Pankaj

Many Lookups are not [SLX] function lookups :

      Application.BasicFunctions.DoInvoke "Function", "Lookup:" & strLookup 'DNL

 .....if you invoke a non SLX OOTB Function lookup using :

Application.BasicFunctions.DoInvoke "Lookup", strLookup 'DNL

Then you won't have the option to return all rows in the group. (the 'first' checkbox)....

you need to

blnUseFunction = True

and not use Application.BasicFunctions.DoInvoke "Lookup", strLookup 'DNL

Many Thanks!

It works!