Hi,

After spending many hours of researching and trying, I am asking for your help…

I have two grids on a form. One grid (GRID1) shows all family in a household and the other grid (GRID2) shows a listing of phone numbers for a family member selected in GRID1.

Each time, a different family member is selected from GRID1, I need to update GRID2 with an index file with filtering on family increment to display a proper phone listing.

Ex> INDEX ON STR(tiMTPmbrno)+STR(ttMTPnincr)+STR(ttMTPtincr) TAG idx_MTP OF cdxPhonebook FOR tiMTPmbrno>0 AND ttMTPnincr=gttMNMnincr UNIQUE

"tiMTPmbrno" holds a value of family member ID (all family members have the same member ID).

"ttMTPnincr" holds a value of family member increment (all family members have different increment number).

"ttMTPtincr" holds a value of Phone number increment for each member (each member can have several phones).

"gttMNMnincr" hols a value of family member increment from GRID1

In order to recreate an index file, I set a cursor to optimistic row buffering from table buffering.

Ex> CUSORSETPROP("Buffering",3,"curPhonebook")
SELECT ('curPhonebook')
INDEX ON ……………..
CURSORSETPROP("Buffering",5,"curPhonebook")

For that, each time I select a different family member in GRID1, I am executing TABLEUPDATE to update modified phone record. Otherwise, I was getting an error message “Table buffer for alias ‘curPhonebook’ contains uncommitted changes”.

I really like to find a way to save the modified phone information when I am finish working with that particular family and move on the next set of family. If any one has any recommendation on how I can address this situation, I will be very grateful.

Thank you.

Kay