Forum Discussion
Solved
Create Table Relationship
Hi, I am trying to join the following three tables without success. Can someone please help? Currently I have joined the Date table to Calls and Agent Times tables using Call Date. A...
Do the agents belong to a company? Is that an attribute you could move up to the Agents table? What are you trying to calculate off the Agent Times table?
Do the agents belong to a company? Is that an attribute you could move up to the Agents table? What are you trying to calculate off the Agent Times table?
I found why I was getting Many to Many error with Agent and Company. Same Agent name was found in more than one company. After sorting that out I moved the Company to the Agent table as you suggested and built the relationship. That is working now.
Thanks for your help.