Hi Kamal

>>When I try to 'Locate' or 'Go Top' etc, it is very slow. So, I try to create an index on the view. But, creating index on this huge table is very slow(4 mins).
>>
>>My question is, how can I make the retrieval fast and still don't take much time on creating indexes while opening my application.

You wrote:
>You dont. The idea with a client-server design is that you ask your users what they want to work on. Use these values as parameters and requery() a parameterized view, thus limiting the number of records.

My situation again:
My users want to see the last record entered into the table whenever they open the app. The last record entered(maintained as a primary key value) is maintained in a seperate table for the users to keep track of.
So, to show the last record in the view, I need to do a 'Locate' or 'seek'
My question is, should make the view parameterized based on the p. key value?
But, if the user searches the table on other fields(which occurs often), should I change the parameters of the view??

Also, Is my situation too difficult to use Client Server??

P.S: The users do lot of locates while using the app.
Hope I'm clear with my question.

Thank You