Thanks Ed, Once again you all make it look so easy :). Appreciate the help.

>>I have created remote views using a connection I have created. Is there a way to define which connection that view uses. Instead of using the default I would like to be able to specify which connection it should use. Thanks!
>>
>>Gary
>
>You can use CREATE SQL VIEW command to define remote view on fly (including connection name).