| displaying rows in one database block according to the focus in another database block [message #83034] |
Tue, 29 July 2003 02:15  |
Victoria
Messages: 152
Registered: July 2002
|
Senior Member |
|
|
Hi,
I have two data base blocks.
One block contains the key.
The next block contains values for the key.(1 key can contain many values)
If i have 10 keys in my first block and each key contains around 12 different values,
when the cursor is at first key record,my second block should have the 12 values corresponding to the first key(in first data block).
i have formed first block with key table.
the next block with value table.
The value table has values for the keys in key table in addition to key.
So how to achieve this and where(in which trigger) i can write my excute query or any other better way of doing this operation.
Please Guide me!
Thanks in Advance
~V~
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
