General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Same view - different content
--------------------------------------
I'm not sure if this is a VIEW question or a FORM question, but I think it's a VIEW question...
I have a form (WIP) which is to display Work In Progress... Work Orders that are not yet completed, and the form is based on views. The views check the Closed field (a DateTime field) and if closed is EMPTY() then the record should be included in the view and displayed on the form.
The system has only 2 users, User1 and User2, who open the form at about the same time (15-20 seconds apart).
User1 opens the form first and keeps it open and sees 83 records.
User2 opens the form second and sees 76 records.
The records that User2 doesn't see are always the most recent.
The most recent record entered into the system was about 5 minutes before User1 opened the form. No other work was being done while User1 and User2 opened the form to show us this behavior.
User2 doesn't see all 83 records unless he exits the application and then goes back in.
Both users are using the same build of the program and accessing the same base tables.
Does anyone have any idea what may be happening here????
TIA,
Rick
--------------------------------------
Next
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