>I create a cursor that pulls up records that are in a specific stage of a sign-off cycle(work flow). The powers that be now don't just want the Que to be a department basket but be able to make assingments at will. This will also give them the option to not assign it at all. What I need my cursor to do is complile the assigned to a particular person plus any not assigned that belong to their department. I would only exclude those assigned to someone else. Note the unassigned have blank fields for assignment.
Use an 'OR' operator.
sele * from yourtable where assign=myname OR (empty(assign) and dept = Mydept)
Good luck getting the view designer let you do this though.
You may need to create the view programatically.
Alek
Alek Massey
- The only stupid question is one left unasked -