>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?

usually you do not browse a complete table - though you can defenetly do that if you wish

you can use a view (createed as a remote view or as the result of a SQL passthrough) and view only a subset of the records of hte orginal table

Arnon