I’m looking for your help, as I don’t know how to handle the following situation with validation rules. Could anybody help me please?
I have a database table "maintable" which is related to either "table_a" OR "table_b".
If table_a_id is specified (>0) table_b_id will be "0".
If table_b_id is specified (>0) table_a_id will be "0".
An entry in one of both fields is mandatory. (Both fields together may not be "0".)
Is there a way to get this situation indicated in the validation rules? Something that produces a validation error like "You need to specify either table_a_id or table_b_id!"…
Thank for your help in advance!