Prohibit modification of date field if the date has passed
I have figured out so much from searching this forum so first I want to say a big THANK YOU!
I am using version 10 on Vista and my solution will soon be shared on a network using Server. All the users will be using it on computers running XP Pro.
One of the things my database tracks is reservations for ski lessons.
I would like to prevent the user from changing the date of a reservation after the date is passed.
I have this working on a button that is used to change the price of a reservation to zero if the customer will be using a voucher.
If [Get(currentDate) > Reservation::Date]
Show custom dialog....
I can't seem to figure out where to place a script like this to prevent the date field from being changed after the fact. (theft prevention)
The date field is in a portal (reservations table) on a layout showing records from the student table.
Thanks so much!!