4 Replies Latest reply on Nov 18, 2009 12:56 PM by StephiSkis

    Prohibit modification of date field if the date has passed

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