External AutoFIll

[#1]

Is there a way in external autofills to have the query evaluate more than one "primary" value?

Example: Establish Account # based on Company # as Primary1 and Vendor # as Primary2?

[Dennis_Seiffert]

Hi Bob,

My company uses a VB script with a CASE statement to allow for multiple types of lookups.  We can pull information from either the member number or a social security number. 

 ' CLng must be utilized to enable use in the Web Client

       Select Case CLng(keysetDef.keysetID) ' Autofill Keyword Set #

            Case 127 ' Accounts by Account #   

                txt = "exec summit.dbo.OnBase_Acct_Lookup '_primaryValue_', , S;"   

                strQuery = Replace(txt, "_primaryValue_", primaryValue)   

           Case 142 ' Accounts by SSN   

                  txt = "exec summit.dbo.OnBase_SSN_Lookup '_primaryValue_', , S;"    s

                   strQuery = Replace(txt, "_primaryValue_", primaryValue)  

           Case Else   

                   Exit Sub

I hope this helps.

Dennis

[John_Anderson4]

I'm pretty sure there's an SCR out there for this functionality. I brought this up at Techquest many years ago and it has come up multiple times on the community as well.

[AdamShaneHyland]

Hi.

From the sounds of it you are looking for External Cascading Data Sets.  At this time the functionality is not available, but has been requested in SCR: #88793.  You can work with your first line of support to add your request to the enhancement.

Take care.