Hi All,
I was just curious as to how you could possibly use a validation rule and have a field from another table as the maximum.
What im trying to achieve is to make it so that certain events are allowed to have a maximum points of 5 where as a couple bigger events are allowed to have 20 points as maximum and i have set up in another table a maximum points field for each event or if there was any other ideal way of doing this.
I was just curious as to how you could possibly use a validation rule and have a field from another table as the maximum.
What im trying to achieve is to make it so that certain events are allowed to have a maximum points of 5 where as a couple bigger events are allowed to have 20 points as maximum and i have set up in another table a maximum points field for each event or if there was any other ideal way of doing this.