help on building up relationships among different tables

From: Kai Huang <khuang_at_andrew.cmu.edu>
Date: Sat, 15 Sep 2001 14:34:56 -0400
Message-ID: <Pine.GSO.4.33L-022.0109151428260.23166-100000@unix1.andrew.cmu.edu>

Hi Folks,

We have a database composed of 20 tables. Some tables have foreign keys from some other tables. Since we used ACCESS2000 before we switch to Oracle, we know that in ACCESS we can just drag the key in one table which is a foreign key to the table in which it is the primary key in the relationship window in access. We want to know if Oracle has similar method of building the relationship among all the tables. The method that we are now thinking is to use triggers, however, the boss said it's a walk-around. He supposed there should be simliar way as access in Oracle to do that. The deadline is coming, we really need help. Thanks a lot for your kind help.

With best regards,
Kai Received on Sat Sep 15 2001 - 13:34:56 CDT