what i do is I create an ODBC connection to the main database located on the server and via this connection, I created another dbc which contains all the remote views I need, from here, I was able to extract all the information I need, store the data on the remoteview and manipulate data by creating an alias in the load event. I have not tried creating a function for requery() yet.
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.