Hello,
I am trying to validate a date field. The table contains a field for PropertyID and one for check-in and check-out dates. When the user enters a proposed check-in or out date, I want a prompt that the date is already taken if it is in the table, but only for the specific PropertyID. Since there are numerous proeprty ID's, i can't just say no duplicates allowed..
Ideally, I would like to have a validation that searches for dates BETWEEN the check-in and out dates as well, and only for the specific PropertyID.
Any help would be TREMENDOUSLY appreciated!!!
Scott Jackson
I am trying to validate a date field. The table contains a field for PropertyID and one for check-in and check-out dates. When the user enters a proposed check-in or out date, I want a prompt that the date is already taken if it is in the table, but only for the specific PropertyID. Since there are numerous proeprty ID's, i can't just say no duplicates allowed..
Ideally, I would like to have a validation that searches for dates BETWEEN the check-in and out dates as well, and only for the specific PropertyID.
Any help would be TREMENDOUSLY appreciated!!!
Scott Jackson