Complex Search

[bees292]

If the user inputs two words (or names in this case) such as "Bloggs Smith", how could I get it to return records with Bloggs & Smith in whatever order they were input?

Example:

Author: Smith, Medin & Rose

User searches: Smith Rose ..........and it returns a hit for Smith, Medin and Rose.

Maybe the Author field would be better not as a text but as a seperate table with a many to many relationship...can someone suggest the best option?

Thanks

 

[Uncle Gizmo]

I am assuming that these are Author surnames >>> Smith, Medin & Rose. If that is the case, you would be better off if you had a separate table to hold the author's names and details, and then link that table to your book with a many to many table.

I belive there are examples available, as the author, book relationship has been discussed in previous posts. There may well be some examples within the forum, and other places that you could study.

I know this is not the answer you were looking for, but I think it's fair to say that part of the problem with your query is that you have not followed the recommended method of building a database.