Forum Discussion

challarajes82's avatar
challarajes82
New Member
7 years ago

Create relationship with duplicate values

Table 1, Table 2 and Table 3. Table 1 Col A values are there in Table 2 Col D & Table 1 Col B values are there in Table 3 Col F. While creating relationship from Table 1 Col A to Table 2 Col D it thr...
Need Help
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
7 years ago

Hi challarajes82 , 

Can you give me a sample of Col D? I can't reproduce your question for lack of it. And have you tried Many-to-Many relationship?

 

Best Regards,

Icey

 

 

challarajes82's avatar
challarajes82
New Member
7 years ago

Sorry for the late response. I haven't rued many to many.

 

 Below are three tables, one is Client loc data and another one is offshore location data and combined information data. I would like to check the discrepancy in hours at each location. so I'm trying to create a relationship with "combined table" col "Emp id -OL" to "Offshore location" col "Emp id -OL" &  "combined table" col "Emp id -CL" to "Client  location" col "Emp id -CL". while creating this its throwing an error stating that " you cant create relationship".

Combined table  Client Location Offshore Location
Table 1 Table 2 Table 3
Emp ID-OLEMP ID - CLName EMP ID - CLNamehours Emp ID-OLNamehours
400565727812John 5727812John40 40056John54
400265824960Pat 5824960Pat40 40026Pat40
 5844808John1 5844808John10 40020Pat136
400206682456Pat1 6682456Pat140 40070Nick35
400707748300Nick 7748300Nick40 40141Sam40
401418579674Sam 8579674Sam27 40116Ram40
401168579958Ram 8579958Ram28 40069chrsty40
400698641880chrsty 8641880chesty44 40006Carrie0
400068641881Carrie 8641881Carrie0 40034Nick236
 8641883Kirsten 8641883Kirsten40 40083Sam140
400348641885Nick2 8641885Nick240 40023Ram140
400838641890Sam1 8641890Sam140 40126chrsty135
400238641896Ram1 8641896Ram140 40133Carrie242
401268641900chrsty1 8641900chrsty140 40096kisrsten136
401338641902Carrie2 8641902Carrie242 40036Nick140
400968641903kisrsten1 8641903kisrsten136    
400368641906Nick1 8641906Nick136    
  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi challarajes82 ,

    I'm sorry to response late. Based on my test, you can only create 'Many-to-Many' relationship between "combined table" and "Offshore location".

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.