String/multiple word search 3

[Nene75]

Hi Everyone:

I would like to develop a search criteria where user can enter multiple words and results are found from more than one record.

For example:
I have a field called "Skills" where the data are:

1. Record1: MS Office, Visual Basic, Dreamweaver
2. Record2: Java, Visual Basic, Flash, MS Office, HTML
3. Record3: Photoshop, MS Office, MySQL, JavaScript

If the user is searching for MS Office, Visual Basic, JavaScript then all the 3 records would be displayed.

Is it possible to do it thru Query or SQL or VB? If yes please guide me how to build the search criteria to find the multiple word to search for in record(s).

Any help provided would be appreciated.

Thanks!

 

[Nene75]

Leslie,

Thanks for the prompt reply.

Am I still breaking the tables as we discussed in earlier replies (tblApplicantBioData with a one to many relationship with Education and tblApplicantBioData with a one to many relationship with skills)?

How and where do I write the code to separate the comma from the multiple words entered?

Do you have any example for this?

 

[lespaul]

Yes, you want to keep your table structure the same (the one to many relationship between your applicants and their skills)

I'm sorry, I don't have a code example, but if you search Forum705 and look in the FAQ there, you should be able to find something. Or post there and someone can help.

Leslie

 

[Nene75]

Leslie,

Thanks for the tip on Table structure.
I'll check and post on Forum705 for further help.

Thanks!