*you might (if the shift code is numeric) *create a multiple field key/tag use MyShiftWorkerTable in 0 exclusive select MyShiftWorkerTable index on str(shiftnumber,1)+workercode tag ShiftWorkerTag if seek(str(RequestedShifNumber,1)+RequestedWorkerCode,"MyShiftWorkerTable","ShiftWorkerTag") * It's there, yahoo else * It's not there, boohoo endif