Can FM do this:
1. Handle records that have a time field (let's call this "LogOutTime".)
2. Always automatically check if the actual PC time is the same or almost the LogOutTime of any record.
3. Blink the record and play a sound when the PC time is the same as the LogOutTime.
I've tried a calculation with container results to at least highlight the record whose LogOutTime has lapsed the actual PC time. But it doesnt refresh automatically. It only highlights when I refresh the layout (through a scripted button). I tried an infinite loop that refreshes the layout every second, but it doesn't allow the user to do anything else on the layout.)
If I think like a VB programmer, I would have a TIMER object that compares each record's LogOutTime to the actual PC time every second (or minute). If it finds a match, it then blinks the record's background and sounds an alarm.
Can I do the same with FM? How?
