I have the following ...
- Code: Select all
Pass_IssuedBy Design
//TYPE = STRING
//CAPTION = Issued By
//SEARCH = YES
//SELECT = SELECT FullName,StaffID FROM (SELECT FName+' '+SName AS FullName, s.StaffID FROM HR_Staff s UNION SELECT '[Anyone]','[ANYONE]') tbl
//ORDER = ORDER BY FullName
//KEYFIELD = StaffID
//DEFAULT = SELECT '[Anyone]' FullName,'[ANYONE]' StaffID
"zzzzzzz "
Pass_IssuedBy Operating
'Admin '
The SQL result is (Admin,ZZZZZZZZZZ0000000000) and KEYFIELD = StaffID, yet the operating value is FullName.
If I swap the parameter order in the query then StaffID is operating, however it also displays on the filter page. I am trying to display "Admin" on the filter page, then filter on the StaffID.
Am I driving KEYFIELD incorrectly?
Cheers,
Neil.