This content has been marked as final. Show 13 replies
I suggest to use the block wizards. This will automatically create synchronization between master and detail.
There is one requirement: there has to be a foreign key in the database between the two tables.
Here is a tutorial:
Edited by: InoL on Apr 22, 2013 4:20 PM
Yes I used block wizard to create Master Detail relationship.And these two table have Primary key and Foreign key as well.
So when I am going to master block F 11 and Control F11 it is showing me one value. Now I have to go to Detail block which has same column defined as foreign key with the primary key in master block showing all the records for that master record value. My requirement to show both at same time.
I dont want to enter Control F11 for these block separately.
Yes I used block wizard to create Master Detail relationship.And these two table have Primary key and Foreign key as well.Did you use the Block Wizard to create a Relationship between the two blocks? If so, the relationship will automatically query the detail block when a record is queried in the master block.
Yes I used block wizard to create relationship. But the relationship was not created when I clicked "Create Relationship" with "Auto-Join data block" checked.
I unchecked the "Auto-Join data block" check box and then I created the relationship.
Please suggest if i did something wrong.
When I am clicking on Create Relationship with "Auto-Join data block" check I am getting error as FRM-10757: No Master data blocks are available.
Anyone please suggest me.
Expand master block object in object navigator, look for RELATION object and check the relation with your detail block if exist delete it.
Now come to your detail block right click on it and open block wizard go to master detail tab un-check auto relationship check box.
Press create relationhip button and on next window select by join condition and set it here according your requirments.
I tried this many times ... but no luck ... I think I have to write some custom code to this populate .. may be in some trigger.
When I am clicking on Create Relationship with "Auto-Join data block" check I am getting error as FRM-10757: No Master data blocks are available.As I said. Use the wizard, but there is one requirement: there has to be a foreign key in the database between the two tables. Check this again.
I have created a foreign key using following script:
create table XXONT_CREDITP_RULEASSIGNMENT(RULE_NUMBER NUMBER,
So, table XXONT_CREDITP_HEADERS is the master, and XXONT_CREDITP_RULEASSIGNMENT the child. Well, if you follow the wizard, it should be able to create the relationship. Be sure to include column RULE_NUMBER in the master and in the detail block (it can be hidden, though).
I have created relationship from block wizard but after clearing Auto Create Relationship check box ..
pls notice that...
Error Message: FRM-10757: No master data blocks are available
No data blocks are available with which to define a master-detail relationship
If the Auto-join data blocks checkbox is:
1. Checked, then the only potential master data blocks are those that are based on tables referenced by a foreign key on the current block's base table.
2. Unchecked, then all data blocks in the form are potential master data blocks, but you must enter the join condition manually.
Additionally,notice that if the relationship exists in the database then a relationship could be created automatically otherwise u should create it manually
Two ways here to go through
1.if two data blocks exist then pls select the master block then > go through the wizard steps to create it.
2.Or create a new form using the form wizard steps before creating any blocks.
Hope it helps