>Exactly what I was after. Seems easy enough. Think I'll wait til tomorrow to try it though, at this end of the country it's after 2am, and being found face down on the keyboard isn't my idea of a good morning.
> Thanks again,
> Randy

Randy;

Garrett has put you on the path you requested. Allow me to suggest you also investigate stored procedures. By using any or all data handling techniques that is, remote views, SQL Pass thru and stored procedures, you can use what is best for your application. Each approach has positive points. Sometimes you may want to use all three approaches in the same application.

One of my favorite apps which I created in 1997 - 1998 used SQL Server and all three data handling techniques from above, an OLE Server and a third party engine used by the shipping industry to calculate cost to ship an article based upon carrier, weight/size and distance, etc. The SQL Pass thru part was fun as I used a table for the business rules and wrote the SQL Pass thru as a method of the form. I simply called the method, passed parameters and the table provided the details. As business rules changed the user simply changed the appropriate row of data.


Tom