Hi Experts,

I have a data entry form class that has a pageframe control with two pages, one showing a grid, the other showing current record contents of the "active record".

This is just fine if I use DBFs as backend data, since it is mere file sharing. This does not augur well though if the same data entry form class is used since ALL rows from a MySQL server database will be fetched (which may run into 100s of thousands)

My question is - what is the best practice for a Client-server data entry form:
1. Get first X number of rows?
2. Show no data at first then have a "new function" to view (in addtion to Edit, New, Delete) with certain filter conditions?
3. I am leaning towards how Yahoo Mail UI does it - but how would you implement the "coordination" of fetching the right number of rows
when user resizes the message header pane?

Thanks In Advance
Dennis