FM::Student Posted April 30, 2009 Share Posted April 30, 2009 Hello, I'm building a large database for the first time and am not sure if I've got everything working right. I have three main tables: Assets, Issues and Project. All three can be related to either of the other two but do not have to. When I go to create relationships between all three (Using Join tables) I can't do it all the way around since there is already a relationship between the two (ie. I connected Assets to Issues and Issues to Projects, but can't connect Projects to Assets). Would this mean I can't have a relation from Assets to projects without having a common Issue? I think this has somthing to do with table occurences but I'm not sure what it all means. I dont know if I'm overthinking it or I just don't enough about tables. Link to comment Share on other sites More sharing options...
bcooney Posted May 3, 2009 Share Posted May 3, 2009 Welcome to FM Forums! Sounds like you could benefit from a read of the Anchor-Buoy method. It's one way to manage table occurrences on the relationship graph, since circular references aren't permitted. Kevin Frank's Anchor-Buoy Docs Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5471 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now