Validation Rules

[k209310]

Hi

I have a table which stores infomation regarding videos and their rating ie: 18, 15, 12. I also have a table of users which stores the date of Birth of the member.


From a form if the member is selected and the video is selected (from a combo box) would it be possible to produce an error message if the user is not old enough to buy the video WITHOUT using code? Ie could i use data validation rules to do the check?

Cheers for any advice

Chris

 

[Mile-O]

You are still going to need to use a function to calculate the person's current age and call it from the Validation Rule.

Here's a couple of age functions.

 

[k209310]

Thanks