As a planning tool, a custom layer can be used to display the desks that have been requested. The layer query would be: SELECT _Moves.desk_id FROM _Moves INNER JOIN _Desks ON _Moves.desk_id = _Desks.desk_id WHERE (_Moves.status = N'pending')