3
To make things simple, I have a database with a form (frmDataEntry) where users can input information (that mostly goes into the main table (tabFeedback) and later search for it. Ideally, I would like to search through user-input keywords to access the files taht match.
To do this, I created another table (tabKW) which stores all of the keywords upon entry and gives them a unique number (KeywordID). I also created a table (tabKWAssign) that would assign the unique number (item #) for the large record from frmDataEntry to a keyword by creating records including the KeywordID, the item #; and a unique number for the link.
For example: should a user input the key words "dog", "cat" into one record; and "cat", "mouse", into another the keyword identifiers would look like 1,2 then 2;3.
There is a listbox (showkey) that queries the tabKWAssign to show the specific keywords for each record Item #.
This seems to all work.
My problem is here: I would like the user to be able to filter the records by searching for keywords and I don't know how. Right now I have a query that works only when its used not in conjunction with the form that is this:
Expand|Select|Wrap|Line Numbers
- SELECT tabfeedback.[Item #], tabfeedback.[Log Date], tabfeedback.SI, tabfeedback.[Feedback/ Lessons Learned Description], tabfeedback.[Reference/Source Document (DOC #)], tabfeedback.Project, tabfeedback.User, tabfeedback.Nominator, tabfeedback.[Feedback Classification], tabfeedback.Disposition, tabfeedback.[Disposition Status], tabfeedback.[Final Disposition Date], tabfeedback.[Last Update], tabKWAssign.KeywordID
- FROM tabfeedback INNER JOIN tabKWAssign ON tabfeedback.[Item #] = tabKWAssign.[Item #]
- WHERE (((tabKWAssign.KeywordID)=[forms]![frmdataentry]![cboKWfind]));
Why won't this work? Should I be going about this a different way? Please help, my job depends on this.
Thank you very much
