Relationship dialog box saying there's an existing relationship between tables
I'm building a volunteer database an and trying to set relationships between tables and when I try to build a relationship between various tables, specifically "clients" and
"volunteer request" and I got the following error " There cannot be more than one relational path between any two tables in the graph. Another occurrence of one of the tables must be added to the graph"
See the attached image. As far as I can tell there's only one relationship between the two tables. Any suggestions?
Yes, go ahead and create the new table occurrence. This is not a new table, just a new "box" on your graph that has the same data source table as the one you tried to connect a relationship line to.
For more on Table Occurrences, see this thread: