DBApprentice
On Error GoTo AWF *****:
- Local time
- Today, 12:10
- Joined
- Dec 24, 2018
- Messages
- 150
Hello again!
Everytime I am staring at my DB´s relationships I get a feeling that I am creating them wrongly. The screenshot is attached.
For instance, the relationship between tbl1Ratings and tbl1Cards, I related the RatingID from tbl1Ratings to the RatingFK on tbl1Cards.
But I sense that I should use a third table to establish the relationship correctly, because a Card from tbl1Cards can have one and only 1 Rating, but a Rating can be applied to one or more cards. Access seems to daunt me to understand it because on the relationship screen it is linking the 1 side of the relationship from RatingID and the many side is coming from Cards´s RatingFK. :banghead:
Sometimes I think they even should be 1-to-1 but I can´t be sure about it and this very same feeling applies to Categories, StatusCards, Areas, Departments and Companies.
Am I building it correctly or I should follow my instintics?
Everytime I am staring at my DB´s relationships I get a feeling that I am creating them wrongly. The screenshot is attached.
For instance, the relationship between tbl1Ratings and tbl1Cards, I related the RatingID from tbl1Ratings to the RatingFK on tbl1Cards.
But I sense that I should use a third table to establish the relationship correctly, because a Card from tbl1Cards can have one and only 1 Rating, but a Rating can be applied to one or more cards. Access seems to daunt me to understand it because on the relationship screen it is linking the 1 side of the relationship from RatingID and the many side is coming from Cards´s RatingFK. :banghead:
Sometimes I think they even should be 1-to-1 but I can´t be sure about it and this very same feeling applies to Categories, StatusCards, Areas, Departments and Companies.
Am I building it correctly or I should follow my instintics?