can anyone help me please

[james07]

on Form:
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

appreciated,

thanks

[rcherch]

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.

[james07]

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.

thanks

[rcherch]

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.

[miritika]

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.