Dan: I'm answering off the top of my head, but for these kind of rules I
would do the verify as you have done, then edit the rule and go to the box
where it puts in the SQL code for the rule. Just add "country IN
('USA','CANADA') AND ...." to the beginning of your rule. At least that's
how I used
to do it, haven't had to try it in a newer RBase version yet.
Karen
> I am trying to create a rule and cannot figure out how to make it work.
>
> I want to verify that a zipcode exists in another table only if the
> country
> column is "usa" or "canada".
>
> I can do the verify using the rule wizard but cannot figure out how to do
> the country.
>
> Any help is appreciated.
>
>
> Dan Goldberg
>
>
