Bill, I don't like rules. They are slow compared to CONSTRAINTS. I would
create a primary key on the column in MAT, and then create a foreign key to
MAT from SEED
ALTER TABLE Mat ALTER COLUMN MatID INT NOT NULL PRIMARY KEY
ALTER TABLE Seed ALTER COLUMN MatID INT NOT NULL REFERENCES Mat
----- Original Message -----
From: "Bill Niehaus" <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 2:15 PM
Subject: Rbase 6.5+ DOS - Setting up rules - verify a value
> 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
>
