Thanks, that did the trick. Dan _____
From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, May 14, 2009 1:40 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: rules problem 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
