Ed,

In C/S you usually want to avoid bringing too much data over the wire. Browsing an entire table can still be practical in some cases. If the table is not too big (a few thousand records or fewer), your network is fairly fast (definitely not a WAN), and you limit the number of fields you display it's not impractical. You may want to give the user the option of viewing everything or doing a search. If they want to view everything they may just have to wait a little while.

>I would like verification that I'm not blowing smoke. We are moving from VFP to VFP/SQL server. I believe that we lose the ability to browse the database in the changeover. I thought that browses go against the idea of client server and instead the user gets a sql of a few close matches....my boss thinks our users will resist the change. Any ideas/suggestions about what to do with users that are used to a Jkey browse?
>
>the only implementation that I can remember was where someone sqled out 15 records before and 15 records after the user's search key...is that the way to go?