Hello,


I am trying to join two tables using the SHAPE command.

"SHAPE {SELECT CustomerID,CompanyName" & _
" FROM Customer ORDER BY CompanyName} " & _
" APPEND ({SELECT OrderId, OrderDate, " & _
" CustomerID FROM Orders} AS rsOrd " & _
" RELATE CustomerID to CustomerID)"



When I execute this statement... I get a syntax of access violation error..


Any ideas?

Thanks.

Alvin