This data buffering thing is killing me. There must be something is don't fundamentally understand.

I have a form that has a grid that holds 'child' records. I have a button to 'Add' new child record and that isn't the problem. The problem is the child record I just added appears in the grid as long as I have the form open, even when I move the parent record around but when I close the form and reopen the form, the record(s) disappear!!!

I have tried to change the buffer mode on the form from 2 (optimistic) to 0 (none) but the newly added record still doesn't get saved!!!

If I exit my program and look at the records in the table from project manager, it displays in the status bar that total number of records have increased yet I'm not able to see the records when I open it in browse window. When I pack the table, the total number of records return to previous number before I added any records.

Can anyone tell me what I'm doing wrong? I haven't had this happen to me since I started using VFP but this is driving me crazy!