Complex Rules and Form Validation

Technical support and scripting issues

Moderators: JRL, Dorian (MJT support)

Post Reply
edauthier
Pro Scripter
Posts: 84
Joined: Sun Apr 13, 2003 1:26 pm
Location: USA

Complex Rules and Form Validation

Post by edauthier » Tue Jul 31, 2007 3:17 pm

I want create a dialog that has rules for the dialog fields
Here's a scenario:
I have a Dialog that has many places for the users to place data, however, I need to make sure that the data is compliant to the rules I would like to build.

So. say there are 5 entry boxes in the dialog (box 1, 2, 3 4)

Box 1 must be contain one of the following- abcd
Box 2 must be contain one of the following- efgh
Box 3 must be contain one of the following- ijkl
Box 4 must be contain one of the following- mnop

Then it gets tricky from there: if box 1 has b,c then box 3 must have j,k.

Not looking for someone to really script this out, just looking for ideas.
The more I work with these scenarios the more complex the expression and the size fo the script.

Thanks in advance, Ed

edauthier
Pro Scripter
Posts: 84
Joined: Sun Apr 13, 2003 1:26 pm
Location: USA

Post by edauthier » Tue Jul 31, 2007 3:27 pm

Just another thought.. should I write the rules in sql or MS Access?

BTW, thanks to Marcus and Pgriff.. for the great database connectivity scripts!!!

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts