>>>>I have a multi-user program where the parent and child table is stored on a central file server. Users on the network add parent records to create a new Parts Quote, and then add multiple line-item records to the child table in a grid. Table buffing is being used.
>>>>
>>>>Sometimes when adding child records in the grid, you will see other people's line items (who are also adding records at the same time) pop up in your grid along with all your line items. When you save your new record, everything fixes itself, but it is very frustrating.
>>>
>>>Using view (for child records) you will get control when grid items will be actually updated.
>>
>>
>>I am not using views.
>Matt,
>This should never occur provided they're not editing records belonging to same parent (or are you using set filter instead of relation ?). Temporarily you could try turning off buffer refreshes :
>Set refresh to 0,0
>Cetin

I am not using SET FILTER. I simply rely on the relationship between the parent-child table to make the grid only show the me child records assoctiated with the current parent record. I have Linkmaster, and relationalexpr set for the grid and all indexes are in place. I used to use set filter for this, but set filter can get very slow with a even a mid-size table.

Everything works fine when only one user at a time is using the system. It is when two people are adding child records that this occurs. Let's say one person is adding child records to Quote Number 00165 and another person is adding child records to Quote Number 00166. The will temporarily see each others records, but when everyone saves the child records, everyhing is alright. It is just those few seconds that they are entering the record and up until they save it. For some reason, the grid thinks it meets the proper critera, so it shows it.

You see, when they click the "Add child record" command button, I append a new record, and replace the Quote_num field parent.quote_no, then set focus to the grid and they type in the remaining data for the child record. They do not (and can not) affect the key field "Quote_no" which relates the child to the parent.

Here is the exact code:
append blank
replace quote_no with quoteinf.quote_no
thisform.pageframe1.page2.grid1.column2.setfocus()