I removed the rules and added constraints as suggested by Dennis, Buddy and Albert. My problem with rules is now fixed. Thanks. Bill N. >>> [EMAIL PROTECTED] 6/18/2001 4:21:45 PM >>> In general, I have found that if you can use system constraints, it is preferable and faster than rules. Contraints provide control outside of screen forms and Set Rules Off. In your example, set up a PK/FK constraint which wouldn't allow a column to be entered in the secondary table SEED unless that value is in the primary table MAT. Dennis ***** At 02:15 PM 6/18/01 -0500, you wrote: >I have two tables called MAT and SEED. I want to restrict data entry to the table SEED such that a value for column ID must exist in table MAT before allowing entry into SEED. > >I went through the menu system for database, modify, rules, verify a value and get to a screen asking for Rule table, Rule column, Verification table and Verification column. > >I have been unable to get this option to work. > >What is the proper way to set up a rule to verify a value. > >Thanks. Bill Niehaus > > > Dennis Fleming IISCO http://www.TheBestCMMS.com
