I have a new problem again.
I am doing a new form in which there are around 8 blocks. All the blocks have their tables in the oracle database.
Each block has 18 columns with the same column & column names. But the values in those columns are different & the values do not match.
The problem lies while i execute the form, it populates only the first block data. Other blocks do not display or populate the values.
I cannot create a master relationship because all the column values are different.
How do i display or populate the values of all the tables?
Please help me. Thank You.
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.