Topic by
pwagner
2010-03-12
21:42
|
Validate using joined tables?
I can't seem to find an example of, or documentation on, how to set up a Validation where two tables need to be joined so values from both can be part of the rule. Is this possible? Can it be extended to 3+ tables if needed?
Thanks, Paul
|
Reply by
kasper
2010-03-12
23:41
|
Hi Paul,
You can't find it because it's currently not possible. One workaround though is to make a database view and run your profile/validation against that view instead.
One simple "join-like" feature that is available though is pertaining to dictionary matching. It IS possible to create a database dictionary based on a column in a database table and match another table's values against that column. But I appreciate that that may not be what you are looking for. So I would go for the view solution.
|
