| Creation of Master Details form Steps [message #478579] |
Mon, 11 October 2010 00:34  |
nagpalgggmailcom
Messages: 16
Registered: August 2010
Location: Bangalore
|
Junior Member |
|
|
Hi All,
1.Can any one tell me the steps to create master-detail form using form builder 6i ,db oracle 9i.
2.Using dept and emp(database table)
3.one more thing difference between cascading/isolated while creating relation b/w dept and emp using join method
thanks alot .
Regards,
GN
|
|
|
|
|
|
|
|
| Re: Creation of Master Details form Steps [message #478734 is a reply to message #478724] |
Tue, 12 October 2010 05:35  |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Use data block wizard and create a master block (based on DEPT table).
Use data block wizard once again and create a detail block (based on EMP table). Wizard will prompt you to create a relationship between those two data blocks. If there is referential integrity constraint there, wizard will suggest columns that make a relation (should be DEPTNO column). If there's none, you'll have to choose columns for master and detail side manually.
That's it.
P.S. As of your third question: these terms are described in SET_RELATION_PROPERTY built-in documentation (Deepak posted a link to it).
[Updated on: Tue, 12 October 2010 05:38] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
