>This is illuding me and I know I have seen the answer posted here, but any searches for the information hasnt turned up what I need. I have a form that Im building a sql table for and I was wondering how I can get other forms to use this sql table with out having to run the sql again or would this be a good candidate for a view?
>
>I have not used a view yet in any of my programs. Any help would be appreciated.
>
>Thanks
>Ron

see the USE command in VFP help. There is an option to add the datasession id at the end of the command to reuse a table in the other specified DS. The problem is knowing what the other DS ID is. I have used this feature on a view I open initially in the default DS (DS #1) on app startup when I need to use it in a private DS.