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