>I have asked this before but still need help. I have a table with records assigned to several different people and some of the records are not assigned. I want to show in a grid based on the log in a set of records that belong to the individual loged on plus all unassigned records. Note I only want to exclude records assigned to another user. Evereyone would see the unassigned. I know it will take two select statements but how can I set them up?

SELECT ;
  * ;
  FROM MyTable ;
  WHERE MyTable.iUserID = <i>LoggedInUsersID</i> ;
    OR EMPTY(MyTable.iUserID) ;
  INTO ...