hello thank you for your reply

im using ms access the columns names are the same in all tabels, i have got id, function and alternatives, basically as im tryin to make a search that allows users to enter in alternatives words for mobile phone functions,lets say, read message this would then bring up reulst of inbox, outbox etc.

i have therfore palced all the tables into one larger table

im now having a problem of creating teh sql statement this is what i have

SELECT MsgF,CAllRegF,ProfileF,SetF FROM MobileTble WHERE MsgN,CallRegN,ProfileN LIKE '%" +sub+ "%'

this works fine when im uisng one field name to be searched, but when i enter in all tables it doesnt work

i also wanted to know how i can make the results of the query dynamic, as in when the user can select a result and be taken to that page??as i then need to allow the user to go to the selected result..very confused as to this one. I would really love if any one can suggest to me how i can do this by exmaple code or something??


Im using JSP as the scripting lanugae, wml and ms Access

thank you for reply