AnsweredAssumed Answered

Prohibit modification of date field if the date has passed

Question asked by StephiSkis on Nov 18, 2009
Latest reply on Nov 18, 2009 by StephiSkis

Title

Prohibit modification of date field if the date has passed

Post

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....

Revert record...

 

 

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!!

Outcomes