My application has to do with the handling of alarms where multiple users are monitoring them in a grid.

When user A wants to handle an alarm, he hits F1, and the record is locked and then flagged as OPEN, it should show up immediately on user B's machine and vice versa.

Can I check the FDATE() of the file from both ends to detect updates?

What's the best approach without grinding the network?

Thanx