Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Foreign Key Value in Master Detail Form Page (apex 3.2.1)
icon5.gif  Foreign Key Value in Master Detail Form Page [message #424531] Sat, 03 October 2009 01:14 Go to next message
Messages: 7
Registered: September 2009
Location: Dhaka
Junior Member

By default foreign key (Emp.deptno) is not inserting from master -detail page.

Master=dept( pk deptno)
detail=emp(fk deptno)

How can i insert it ?

Engr.M.K Chowdhury
Re: Foreign Key Value in Master Detail Form Page [message #424572 is a reply to message #424531] Sat, 03 October 2009 22:08 Go to previous message
Messages: 540
Registered: February 2008
Senior Member
100% it will work. On creation of your master-detail page, you would have got link page where master key, detail key will be displayed. if you would have not got it, then relation of foreign key is not correctly established.

If your dept column is varchar2 in dept and in emp table, i shall suggest one other method. In the dept table you add one column as rec_id and using sequence create it as primary key. Dept name column make it as unique and index it separately. In the emp table link as foriegn reference as was done earlier. (in this case do not your dept primary key as foreign key since it is rec_id) Now to create fresh master detail page. if you are not able to create this page and upload in apex.oracle.com and pass the url.

[Updated on: Sat, 03 October 2009 22:09]

Report message to a moderator

Previous Topic: open links in the same session
Next Topic: Monitoring the timer running in the front end in APEX
Goto Forum:

Current Time: Sat Nov 27 17:27:31 CST 2021