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