>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 ...
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up