I was created a database that store the article fields or ….
This article(entity) has a field that has more than one value(I called keyword).
The relation between article and keyword(in my idea) is m:n .
Finally , I design two tables, one article and other, keywords as below;
1- article(ID, title,descript,index,abstract). ID= primary key
2- keywords (id,keyword). ID+keyword=primary key , ID=forign key
do any work that implement these two tables with one dbgird that show the real field of article and another field
( example keywords) when user click on this field the values of the field will show(the delete,add and modify available for values) ?
thanks a lot