Restrict save

Hello, I'm creating an application for timekeeping. It has two tables, a functional table and another registration table. The operation table has the entry time for each operation. I would like to restrict registration to 15 minutes before entry time and 15 minutes after entry time. For example: if entry is at 07:00, the operation could only register from 06:45 until 07:15. Can anyone help me, thank you in advance.
0 1 40
1 REPLY 1

Not 100% sure about your table/column structure, but I assume you have parent and child tables and you would like to allow the Child record only between 15 minutes before or 15 minutes later. You could do this with a validation in one of your columns something like AND([Created]>[ParentID].[Event]-"000:15:00",[Created]<[ParentID].[Event]+"000:15:00")

Top Labels in this Space