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#