Library(Help desperately required)

Hi
I would like to create a database for all of my research papers, journals, etc from over the years.I would like the items in it to be sorted by subject, but I need them to be cross-reference to other subjects so that when I do a search on a subject,it would bring up records of articles with relevance to that subject.

How would I setup the tables for this?

What can I do??

Based on what you a stated i would do the following



tblDocuments
DocID (PK), DocTitle, DocDesc, DocSynop, DatePub, WherePublished, etc

tblSubjects
SubID (PK), SubDesc

tblDocSub
DocID (PK/FK), SubID (PK/FK)

This lets you maintain basic info on your Articles and Subjects and allows you to assign multiple subjects to a document for searching purposes.

You will need to modify this table structure to meet your specific needs



"What can I do??"

Depending you your requirements, You can hire one of use to make you a nice system.
OR
We can help you make your own system.

Good Luck

S-