General information
Category:
Forms & Form designer
Title:
Problem in ChildGrid of one-to-many form
I encounter a problem that the childgrid incorrectly showing the child record belonged to other header transaction while more than one user are entering records into the same child table. Under the single user environment, the childgrid has never been a problem. The childgrid are directly binding to the base table. If I click on the childgrid again after another user's record popup on my form, the childgrid will filter out this unwanted record. We know the alternative to bind the child base table is to bind to the view with proper key. However I want to exhaust all possible solutions before change to the view.
I also tried to set up the LinkMaster, RecordSource and Childorder properties in the form. But this does not fix the problem. By the way, the grid is in table buffering with optimistic mode.
Thanks in advance!
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only