multiple entries

[potts]

I am creating a database to hold information pertaining to research articles. Ultimately I want to create a search form to find the article I want by certain categories.

Now to the point ...

I have 2 tables. 1 is a referential table of keywords, the other is the main table, holding the article info. Each article will have a number of keywords associated to it. What I need to know is -

1. Do I need more than one field in the 'articles' table relating to the 'keyword' table to hold all the different words?

2. How does this effect my ultimate goal of a search form (should I categorise the keywords)?

 

[Fuga]

If you´re going to do it this way, this is how I would do it:

table 1
articlenamefield, articleID(PK)

table2
keywordfield, articlID

If you want to categorise keywords, you´ll probably need an additional field in table2.

Fuga.