Re: Inter-table references

Dale wrote:
> I don't even know if my subject line makes sense...
>
> I'm trying to find out if there are ways that similar fields between tables
> can be made dependent on each other for their values. That is, if I define
> two tables with some similar fields, can I force one table to be updated
> from the other outside of running a script to do so.
>
> I guess I'm looking to find out if Oracle has any attributes that would
> cover such requirements, something that is a property between the tables or
> such.
>
> That's as best as I can explain it. Hope this isn't too nebulous.
>
> Thanks.
>
> Dale

What I think you are referencing is a Foreign Key Constraint, also known as a referential constraint. It is used to constrain the values in one field to those of another field in what is often refered to as a lookup table.

www.psoug.org
click on Morgan's Library
click on Constraints

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)