>I have a application that uses Bill.DBF and Master.DBF in Shared.
>The application runs fine on single PC.
>
>Now I have been asked to retrive Data from Bills and Master.DBF at CSC counters located at 10-15 miles away. CSC counters are around 20-30 in city.
>
>So I have developed a small interface application for CSC in which there is a FORM that will ask to input the required Account Number so that DATA will be retrieved from main application.
>
>I will be using select * from Bill…. Like commands to retrieve Data. But my problem is I do not know that How I should I establish link between my CSC application and Main application before I execute Select * from..... I mean to ask that what are the commands/procedure I need to run before using select * from Bills….

If you want to access the remote tables directly you'll need to set up some sort of VLAN or other remote access connection.

Another thing you could do would be to install a query utility at each remote site. This utility would SELECT ... INTO TABLE SomeTable. The remote locations could then e-mail SomeTable.DBF to you.