Search Form

[lukestkd]

Hello,
I am developing a system for my university studies which will allow me to manage the resources I have collected through my time in education.

I currently have three tables, one which stores the 'Article Data', such as title, hyperlink to resource, date published etc.

2nd Table has a list of keyword in

3rd Table links the articles to keywords through one-to-many relationships.

I need to create a form which would allow me to search a combination of keywords to locate a relevant article. e.g. if an article has the keywords "Regeneration" "Local" "Urban" "Social", I would select those keywords and it should find that (or any other relevant) article(s).

How can I do this?

Kind Regards, Luke

 

[John Big Booty]

Have a look at this search tool it may do what you want.

 

[lukestkd]

Many Thanks for that, I've had a good look at it but I'm struggling to fit in to my system: I meant to mention this above:
I would like to select the keywords to search for from a combo box, with a maximum of five keywords at a time
I would then like to be able to select a start and end date for the search (as the date of article is stored in the article table)
Then I would like to search the Source (i.e. online, newspaper etc)
Finally I would like to search the "Country" field (stored in the article table).

I've attached the system and .png file of the sort of idea I had for the form, could anyone lend some help with this?

Many Thanks, Luke

 

[John Big Booty]

Sorry. I couldn't open your DB, if it is 2007 format can you save it as 2003 format and re-post.