>I have several tables in my database. I want to take three of the tables which have a field called giver. I want to compile a distinctive list of names from these tables using this field and use this list to populate my combo box. Please help.

Off the top of my head...

SELECT giver from TableA ;
UNION ;
SELECT giver from TableB ;
UNION ;
SELECT giver from TableC ;
INTO CURSOR cGiverAll

SELECT giver ;
  FROM cGiverAll ;
  GROUP by giver ;
  ORDER by giver ;
  INTO CURSOR cGivers

Then load this into your combo.