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.
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 have created a foreign key using following script:
create table XXONT_CREDITP_RULEASSIGNMENT(RULE_NUMBER NUMBER,
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