Re: [Q] When to use foreign keys

TallGuy wrote:

> For example, I've got a master and detail table. Right now, the
> common data element would be ss#. It must be unique in the master,
> but not unique in the detail table.
>
> A Foreign key kind of makes sense (for ss#), but I can not make it
> work. The unique of the master table wont let me add data to the
> detail table.

     Would you mind to specify the ORA error and most importantly, please give the error message?

-- 
Name        : Lun Wing San
Title       : Senior Consultant of Lun's Oracle Solution Company
              System Administrator and Oracle DBA of the Quick Response Center
              Oracle Developer of the Hong Kong Productivity Council
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841