pi********@hotmail.com wrote:
if you want to search more than one or two fields for the same word(s),
then your database structure sounds a bit suspect. Why would you have
the same type of data in more than one field in your table? Could you
give a scenario illustrating what you are trying to implement? Perhaps
your design is less than ideal.
Yes my design wasn't quite right but I fixed it. When I meant search
forms I meant be able to find like key words. My fields contain long
sentences such as "Problem/Resolutions" so when people want to refer
back to these or for an easy look up they could just type in a keyword
and all the fields that have that word would come up.