>My users are experiencing this weird problem:
>
>User A creates a new record and starts entering information. User B
>then adds a record and starts entering information. User A then saves
>their record. A few minutes later, User B's record will "switch" to
>User A's saved information and all of User B's info will be lost!
>
>The form consists of three tables, a parent, a sibling (one to one) and then a child on a grid (one to many). I am using Optimistic Row
>buffering on the parent and Optimistic Table buffering on the child and the sibling.
>
>I know this isn't very much information, but Im looking for anyone out
>there who has ever run into this problem before. I have 5 users
>creating new records at the same time and I'm hoping its my code and not a VFP buffering problem. I'd like to avoid changing over to views if I can... guess Im looking for a quick fix.
>
>Thanks in Advance!
Eric,
Here's more questions, not answers, but they may give you some ideas.
1. Have you checked the Unique IDs to make sure that each user is adding a different value?
2. Does this happen with all 3 tables?
3. Does it happen if you switch the child tables to Optimistic (or even Pessimistic) row buffering?
4. Can you reproduce the problem on demand? If so, have you walked through the code with DEBUG watching your record #s?
5. Could it be related to the REFRESH value? What is its setting?