RULES 'USA or Canada - Post code not in Table1' +
FOR `Table2` SUCCEEDS +
WHERE EXISTS (SELECT ZipCode FROM Table1 +
WHERE Table1.ZipCode = Table2.ZipCode ) +
OR (Country NOT IN ('USA','Canada'))Dennis -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Thursday, May 14, 2009 3:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - rules problem 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
