Jump to content
Sign in to follow this  

Circular Relationships

Recommended Posts


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.