I am creating a database in MS Access 2010, I have 6 tables. My question do all 6 tables need to have either a direct relationship (primary key to primary key) or Primary Key to Foreign Key with each other?
ITNoobie
0
Newbie Poster
Recommended Answers
Jump to Posthaving relationship is good thing to do in database, but it is not mandatory at all. You will not see much pk to pk relation (1 to 1). Generally you will find (pk-fk) kind of relation much in database.
Jump to PostNO its not cumpulsory, but if you wish you can create relationship to avoid errneous records
All 6 Replies
urtrivedi
276
Nearly a Posting Virtuoso
ITNoobie
0
Newbie Poster
urtrivedi
276
Nearly a Posting Virtuoso
boblarson
15
Junior Poster in Training
ITNoobie
0
Newbie Poster
boblarson
15
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.