above is a datasets, fields are filename,keyword. store in a ms access table. both filename and keyword fields are string. i.e. 'xxx.doc' is a string, 'abc,caa,funny' is a string
if a user input "abc", the program should return filename associated with it , i.e. xxx.doc and xyz.txt
since the datasets may be very large, the algorithim to retrive the keywords from keyword string and then compare in order to get the associated filename should be efficient.
anyone has the script or can provide some idea? like what data types., method i should use....etc
thank you for enlightening.