Jack ---

Do you have SET MULTILOCKS ON for the current datasession? If this form is set up as using Private Datasessions, most SET commands having to do with data need to be run in, preferably, the BeforeOpenTables method of the DataEnvironment. If this is the case, consider using a view of the child as the grid table and then a DO WHILE...ENDDO to resolve any conflicts on a row by row basis when saving.


>I have set my parent table buffering to 3, child table to 5.
>My problem is when two users are simultaneously entering data on
>the child table using a grid, the other one receives "Attempting to lock....." when entered data is validated by seeking existing record on a reference table. One has to wait for the other to finish, this defeats multi-user feature.
>
>Shouldn't this happen on buffered table ?
>What else must i do?
>
>I have set multilocks on.....set the form buffermode to Optimistic..
>
>PLEASE HELP!