The question or heading for this could actually be this:
How to populate the values for all blocks in which we cannot create master-detail relationship ?
Can I at least know if it is possible to populate values (execute_query) for multiple blocks where there is absolutely no relationship between the tables in the same form?
if your form has truly disassociated tables, then you could simply use a key-exeqry trigger at forms level to travel to each block in turn and perform an execute-query built-in, eventually returning to the starting block.
In this case you would use the block where clause to constrain each table to the appropriate set.
If however, the database has no relationships between the tables but the data content has some corelation, then you could craft a forms relation manually.
Thank You so much 'Rod'. It worked perfectly.