[Q] When to use foreign keys

I'm new to the world of Oracle, and don't know when it would be appropriate to use foreign keys.

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.

Thx for your help.

Don Received on Wed Nov 06 1996 - 00:00:00 CET