Hi,

New to Access learning... I have
Table 1.. Publisher
Table 2.. Books

I was wondering .. Should I create Transient Third Table e.g.
BooksPublisher..
Or Should I put PublisherID key AS Foreign key into Books Table ?
which would be Practical

E.g Books Publishers
BooksNPublishers
Pk BookID Pk PublisherID PK
BookPublisherID

Fk BookID

Fk PublisherID

OR

Publishers Books
PK PublisherID PK BookID
Fk
PublisherID

Could Somebody guide me

Thanks in Advance
Ahmed Khalak