How to combine data from three tables into one form?

[anna brown]

hi there,
i have three tables with independent data.
example:

table 1: red, white, green, ....
table 2: big, small, large, ....
table 3: Mary, Adam, John, ...

I need to create a form with options:
search table 1: (choose) red
search table 2: (choose) small
search table 3: (choose) John

so i have displayed some data from all the tables at the same time



Pressed for time, preatty new in this field.
Help
Thanks

[malcolmk]

Not sure what you want! You want three dropdown combo box to choose a value from a list for each table?