Hi everyone,
I have jumped straight in with this one. My intention is to create a page that allows users to search for a specific record (word) from a SQL Database. Now the problems is that what the user is searching for will not be in just one column in the table, but ten. Reason being is that person who set up the DB originally designed it to have ten areas of projects for the user to complete, so the fields are Project 1, project 2, etc..etc, so searching for a specific project is not as simple as looking in one column/field. I have created ten views in SQL and hard-coded a search criteria for testing purposes, and then created a union view to collect and display the results of those ten views, this works fine but now I have got to create a page in DWMX for it. I have a form with a list box that displays all the projects a user may search for, once he finds the project they will click a button and a list will appear displaying all the members of staff working on that project.

What i'd like to know is am I going about this the right way and does anyone have any advice on how to use the views I have created in order to lookup the value from the list down box to search all 10 views to find and display the data ?

Mitch....

Its really not as hard as writing so many views if all the columns are in the same table.

You could do something like

SELECT *
FROM tblname_here
WHERE column1 LIKE '%variable%' OR column2 LIKE '%variable%' OR column3 LIKE '%variable%'

...and so on.

Hope that helps!

Daniel