books, journals, articles authors

[timbits35]

Hi,

I have redesigned a database for tracking books, journals, journal articles and authors. So far I have these tables with some
of the fields that I have included:

TblBooks
BookID - primary key
CallNum
Title

TblAuthors
AuthorID - primary key
FName
Lname

TblBooksAuthors
BookAuthorID - primary key
BookID - foreign key
AuthorID - foreign key

However, some of these "books" are actually journals and each journal has
several articles. I am not sure how to deal with this. Should I create 2 more
tables

TblJournals
JournalID - PK

TblArticles
ArticleID - PK
JournalID - FK
AuthorID - FK

Then I would be repeating a lot of the same fields in the TblBooks and
tblJournals like Call number, Publisher, Subject, Language, Edition etc. And
then how would I put this all on the same data entry form. Or do I make 1
data entry form for books and 1 for journals?

I currently have the tblbooks as the main form with tblAuthors as the subform. Would I have 2 subforms?

Thank you,
Liane

 

[plog]

Change tblBooks to tblMaterials and add a field called something like 'materialtype' which lets you know if it is a book or a journal.