DATA Entry form [message #596488] |
Mon, 23 September 2013 13:07 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bf3da437af68df59ca577834d110f810?s=64&d=mm&r=g) |
lakshman0145
Messages: 12 Registered: May 2013 Location: HYDERABAD
|
Junior Member |
|
|
I need to be able to insert data into multiple Tables by using a single form (artists, songs, albums, genres).
I have relational tables
(artist songs, album songs, song genres) that contain the ID of the relevant table.
How do I go about creating a trigger/sequence/function/package
to get the data from a form into the relevant tables automatically and so they all link up correctly.
Apologies about the Vagueness however I am stumped as to know where to start.
I am using Oracle XE as the Database, with Oracle Application Express as the front End application.
Any answers would be extremely Helpful.
|
|
|
|
|
|
|