Hi Gnana,

I would suggest that you use a view for the phone table and bind your grid to it.

HTH

>Here is a general question about buffering.
>
>Scenario: I have a form and several tables in the data environment of the form. The buffering mode is set to 5 (optimistic table buffering)
>Lets say my form is a customer form. I have a grid in the form which shows all the phone numbers of the customer. The record source for this grid is an SQL statement that acts on 3 other tables. This grid is read only. To add a new phone number I run a modal form to get the phone number, extension etc. Once I have the new phone info, in my initial form, I add records to the corresponding tables (phone, extension etc) and rerun the SQL query that is the recordsource of my readonly grid. The grid (cursor of the SQL query) does not pick up the newly added phone number until I do a save in my current form, thus executing tableupdate on all the tables in the data environment. I would like for the grid cursor to pick up the new phone numbers (from the buffered data) even before I do tableupdate. Is this not possible in VFP or am I missing something?