I have a DataEnvironment set up with one command and on child command if I run a report with no sql it works fine it takes data from both ,I would like to set up an sql but I am having a problem getting the results I want for example: I have 2 tables in my database "color" and "shapes"
and DataEnvironment is set up as Color as command and shapes as child command I want to select the color and have the shape as well on a report "red" "triangle"
I tried doing the following"
DataEnvironment1.commands("color").commandtext= _
"SELECT * FROM shapes,colors WHERE color= '"&Search$&"'"

but this generates an error "The specified field "color" could refer to more than one table specifed in your FROM clause" The color field is what I used to create the child command with...any ideas?