Hi,

I am having an issue where i created a relationship between two table ie. a parent table (1) and a link table (many). I mistakingly remove the link but now I can recreate it. I am getting the following error

"There cannot be more than one relationship path between any two tables in the graph. Another occurence of one of the tables must be added to the graph....."

Has anyone come across this problem or is this the way FMP is supposed to work? Is there any implecations with creating a TO?

Are TO's the equivilent of views or alias and therefore is the data the same as what is in the table?

a screen shot of the graph is attached i want to create a relationship between assignment and assignCommentLink.

A relational line cannot be a closed loop, linking through tables in 2 different directions, then back to itself. Because then the path is ambiguous, it could go either way to the specified end. It doesn't matter if one path is long and one is short.

If you had a connection, broke it, then later could not reattach it, it is likely that in the meantime you'd attached the table occurrence to one of the main tables' occurrences, so that the reattachment would be a closed loop.

You didn't say which, and I couldn't tell. What was it you wanted to do? If you post the graph again, could you collapse your table occurrences to just the link fields. This is a pet peeve of mine when I look at other people's graphs. It's kind of a spread-out mess when they are all left wide open; it's simple to collapse them to only the relevant fields, just click the box in the upper right; it toggles 3 views, you want middle one.

Thanks for your reply. I can see clearly now. basically we can not have any recursive paths.