Jump to content
Sign in to follow this  
FM::Student

Circular Relationships

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.