Database design, how to update foreign keys?
Posted by:
Jan Geo
Date: July 21, 2006 04:01AM
Dear all
I have a table main author with primary author_id and table study with pk study_id. A study can have only one main author but a main author can have participated in more than one studies so i have a relationship study (N) - (1) author. When i input values to table author through a web form is the foreign key(author_id) of table study automatically been updated? How could i do that automatic updation?
Looking forward to your answer
Cheers
Subject
Written By
Posted
Database design, how to update foreign keys?
July 21, 2006 04:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.