Nick,
It's actually a good question, but in this case I dodge the bullet....
the field's name is OrderItems.Close_Date

I'll be gone for the weekend and will be back at this Monday morning.

Rick
----------------------
>I know this is a stupid question. What is the name of the "closed" field? Is it a reserved word?
>
>>Hi Nick,
>>
>>User1 was the person who last touched those "most recent records" that user1 doesn't see. Also, there is a timer on the application that checks a table for new content. If that table has new content the timer creates a new Order record and the accompaning OrderItems record. It creates the new items with an empty Closed field, so these items should appear on the form the next time the views are created or requeried.
>>
>>The data is on one server and only accessed by this VFP app and only using views.
>>
>>It's a good thing I like puzzles.
>>Rick
>>-----------------------
>>>Hi Rick,
>>>
>>>Who updated those most recent records that User2 does not see? I assume it is some other app that fills the Work Orders, right? Where are the data stored (some other server, I assume) ?
>>>
>>>
>>>>--------------------------------------
>>>>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
>>>>--------------------------------------