I'm having a tough time with a grid on a form. This form and grid worked fine in VFP 8 but since we moved it to VFP 9 it's not working properly. We have a screen based on an employee table with a grid that has child data in it (transactions).

The transactions in the grid are ordered chronilogically and all that seems to work great. I add a record to the transactions table and no matter what date time I use it appears at the bottom of the grid. So let's say I use some date and time that should land somewhere in the middle of the data (that I would need to scroll up in the grid to find if it were in the right place). If I try to refresh it does nothing, my new record stays at the bottom. If I try to setfocus() on the grid, the grid re-orders correctly but the record pointer is still on the last record and now I have to scroll up to find my new record I just added.

Both employee and transaction tables are VFP 9 tables. I'm wondering if this is a bug in VFP 9?

Thanks,
Don