i only have the views open, so i know that i don't have any problems with conflicts with the tables. i can get it to work in the command window fine but it won't work in my program. i'm going to look at my view settings and see if they vary from the command window to the program.

pbd