Many to Many Relationships
Date: 04 Dec 2001 03:44:57 GMT
Message-ID: <20011203224457.11238.00001101_at_mb-fi.aol.com>
I've posted this in comp.databases.ms-access so if you've seen it, sorry for the cross-post.
Hello,
I'm designing a database, in A2K, and I understand that in relational databases many to many relationships can't be directly implemented and that you need a junction table. What I am more concerned with is why.
This is my scenario: I have tblCase and tblLawyer. tblLawyer is a lawyer that represents either the buyer, the seller, or the bank. Why wouldn't I be able to make three attributes in tblCase, entitled SLaywerID, BLawyerID and LLawyerID (Seller, Buyer and Lender, respectively) and have each of those refer to a specific record in the tblLawyer table. This would be a many to many relationship, each instance of tblCase contains multiple records from tblLawyer and each Lawyer in tblLawyer can exist in more than one record of tblCase. I know how to implement this by using a junction table, but I am more concerned with the why.
Thanks in advance,
Adam Received on Tue Dec 04 2001 - 04:44:57 CET