I have a form validation challenge for which I humbly request your support.
I am building a database for phone bill management. Phone numbers are assigned to users for a period of time, and then the same number is assigned to a different user for another period of time. Users should be billed for their usage only for calls made while the number is assigned to them.
I have a table called "[Phone Assignment List]" which captures [PHONENUMBER], [Full Name], [Date Issued], and [Date Returned].
[Date Issued] is a required field, but [Date Returned] is not.
I want to add a validation rule on the [Date Issued] field such that when I populate the field, the rule evaluates that the date value for this field, associated with this phone number, does not fall within the [Date Issued] and [Date Returned] time fence for any other records with this phone number (otherwise there would be a period of time when two users could have the same phone number, which is not allowed).
Can you help?
Additionally I would like a report which would identify any ownership time gaps for any phone numbers, but this is kind of a separate challenge.
Thank you!
I am building a database for phone bill management. Phone numbers are assigned to users for a period of time, and then the same number is assigned to a different user for another period of time. Users should be billed for their usage only for calls made while the number is assigned to them.
I have a table called "[Phone Assignment List]" which captures [PHONENUMBER], [Full Name], [Date Issued], and [Date Returned].
[Date Issued] is a required field, but [Date Returned] is not.
I want to add a validation rule on the [Date Issued] field such that when I populate the field, the rule evaluates that the date value for this field, associated with this phone number, does not fall within the [Date Issued] and [Date Returned] time fence for any other records with this phone number (otherwise there would be a period of time when two users could have the same phone number, which is not allowed).
Can you help?
Additionally I would like a report which would identify any ownership time gaps for any phone numbers, but this is kind of a separate challenge.
Thank you!