Search results

Thanks guys! Now I must try out what you have suggested.

Yes, that’s correct. I have three tables just as you assumed, because based on what I have read elsewhere that’s thee solution. Initially I thought that using AND-operator would be obvious way to do the queries, but I haven’t figured out how to implement that kind of queries using the table...

Thanks Sum Guy, I hadn't thought it that way. Using different keyword fields might really be a viable option in my case. However, I would prefer solution where I don't need to care about hierarchy of the keywords. MiikkaT

I would like to make an Access database for my collection of scientific papers. From that database I should be able to find articles using descriptive keywords. The problem is I haven’t figured out how I could search for the articles needed using multiple keywords at the same time (eg. papers...