Forum Discussion

armchairexpert's avatar
armchairexpert
Icon for Helper III rankHelper III
5 years ago
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...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    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?

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

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?

armchairexpert's avatar
armchairexpert
Icon for Helper III rankHelper III
5 years ago

jdbuchanan71,

 

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.