lets say I have 3 display items and 3 text items.
and I have 2 tables to work with, and their names are:
black and white.
when I put in a number in the text_item with a number between 1-99, I want the content from the "black" table to appear on all the display_item box. and if the number is between 100-1000, I would like to content from the "white" table to be displayed.
and I have another display_item that I would like to display the name of the table, in which the result came from ie.
black table = between 1-99
A few questions, that might help clear this up.
1. Are you using data blocks? (i.e. do you have a white and black block)
2. Can you use non data blocks to use pre-query and post-query triggers on the block to retrieve the data?
3. Can you use an when-change to fire a query that populates the data?
Can you give us your layout scenario to help you better.
no, i'm not using data block
here's an example
if I were to type in a number 7 in the first Text_item area, the display_item on the left would display something like "black car" or "black dog" etc.
and if I type in 117, it would display "white car" or "white dog"
its a really simple, its just that I'm having hard time explaining it. thats because I'm not good with this if then else statement stuff.
hope this help.
look for a trigger on the text_item for when-validate-item/when-change-item. I don't have Forms with me so I cannot look it up for you.
This is where you would use a piece of pl/sql to populate the display_item.
hope this helps.
what u need to do here is write 2 triggers one at the item level i.e. when-validate-item and another at the block level post-query and issues a select statement.
Click Here to Expand Forum to Full Width