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
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.
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.