FSe User Lookup SELECT OwnerID, FSL_TableCode, FirstName, LastName, EMail, FSPro_UserID, FSPro_Password, LoginEnabled, StaffMember, orgType, orgid, Organization = CASE WHEN tbl_FSPro_Members.FSL_TableCode = 'ASC' THEN (SELECT ascName FROM tbl_ASC_Associations WHERE tbl_ASC_Associations.AsscID = tbl_FSPro_Members.OwnerID) WHEN tbl_FSPro_Members.FSL_TableCode = 'BRO' THEN (SELECT broker_name FROM tblBrokers WHERE tblBrokers.BROKER_ID = tbl_FSPro_Members.OwnerID) WHEN tbl_FSPro_Members.FSL_TableCode = 'CHO' THEN (SELECT cho_name FROM tbl_CHO_Operators WHERE cho_id = tbl_FSPro_Members.OwnerID) WHEN tbl_FSPro_Members.FSL_TableCode = 'DST' THEN (SELECT cdr_dstname AS DSTName FROM tbl_CDR_Distributors WHERE cdr_recordid = tbl_FSPro_Members.OwnerID) WHEN tbl_FSPro_Members.FSL_TableCode = 'MFR' THEN (SELECT MFR_Name FROM tblManufacturers WHERE MFR_ID = tbl_FSPro_Members.OwnerID) WHEN tbl_FSPro_Members.FSL_TableCode = 'MISC' THEN (SELECT CompanyName FROM tbl_MISC_Companies WHERE OwnerID = 1 AND FSL_TableCode = 'MFR' AND MISC_ID = tbl_FSPro_Members.OwnerID) WHEN tbl_FSPro_Members.FSL_TableCode = 'OPR' THEN (SELECT CompanyName FROM tbl_OPR_ClientOperators WHERE OwnerID = 1 AND FSLTableCode = 'MFR' AND OperatorID = tbl_FSPro_Members.OwnerID) ELSE (tbl_FSPro_Members.Organization) END FROM tbl_FSPro_Members WHERE 1 = 1 AND OwnerID = AND staffmember = AND (FirstName = '#variables.First#' OR LastName = '#variables.Second#' OR email = '#variables.first#') AND (FirstName LIKE '%#variables.First#%' OR LastName LIKE '%#variables.Second#%' OR EMail LIKE '%#variables.Second#%') AND Email like '%#variables.String#%' AND FSPro_UserID LIKE #val(variables.String)# AND FSL_TableCode = '#form.CompanyType#' ORDER BY OwnerID, LastName, FirstName ;
FirstName \ LastName \ Email:  
Search Type:  
Like Match CHECKED />
Exact Match CHECKED />
Company Type:  
ANY CHECKED />
ASC CHECKED />
BRO CHECKED />
MFR CHECKED />
MSC CHECKED />
OwnerID:  
Is Staff Member:  
Yes CHECKED />
No CHECKED />
MAXIMUM OF 500 RECORDS RETURNED
OwnerID FSL
TableCode
Orgranization UserID FirstName LastName Email Password Staff Member Login Enabled Org Type Org ID
#qry_userlookup.OwnerID# #qry_userlookup.FSL_TableCode# #qry_userlookup.Organization# #qry_userlookup.FSPro_UserID# #qry_userlookup.FirstName# #qry_userlookup.LastName# #qry_userlookup.Email# #qry_userlookup.FSPro_Password# #YesNoFormat(qry_userlookup.StaffMember)# #YesNoFormat(qry_userlookup.LoginEnabled)# #qry_userlookup.orgtype# #qry_userlookup.orgid#