can there be two foriegn keys in a table - both the foriegn keys reference a primary key in other table. (The table is going to be built on MYSQL backend - connected to MS access front end)
I have a group of items that I need to mark different categories. Some items belong to both the categories.
Hence I am trying to build a table like
table name - Item-categories
Itemid, categoryid1, categoryid2
1 1 2
3 1 2
(Categroyid and categoryid2 are the foriegn keys and represent the catgegoryID in the category table).
If the above is not legitimate design, how to acheive the best.