Problem writing into several database tables using one submit form

Hi,

I'm totally new in programming using JDeveloper/Oracle

Version of JD is 10.1.3.2.0

Problem:

I have database with tables User,Project,Proj_member

On web application user enters it's email for user table and project name for project table.

After button click new row should be put into all 3 tables,Proj_member alligates them by using user_id and project_id just made.

I used data model with toplink,session bean ,this oracle tutorial to be clear:

http://www.oracle.com/technology/obe/obe1013jdev/10131/10131_adftoplink/master-detail-edit_page_adf_toplink.htm

And managed to submit row into one table just

My question is,which methods or basic things I should use to make it happen that by submitting one form all 3 objects are created in a row (new user,new project and new pr_member eventually)

Any tips,tutorials links..all are welcome

Thanks in advance,Roland

[946 byte] By [Roland44a] at [2007-11-27 8:15:06]
# 1
U can use a database trigger to insert into any number of tables u want.
CPGuptea at 2007-7-12 19:59:49 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...