Forum Discussion
Create relationship with duplicate values
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
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-OL EMP ID - CL Name EMP ID - CL Name hours Emp ID-OL Name hours 40056 5727812 John 5727812 John 40 40056 John 54 40026 5824960 Pat 5824960 Pat 40 40026 Pat 40 5844808 John1 5844808 John1 0 40020 Pat1 36 40020 6682456 Pat1 6682456 Pat1 40 40070 Nick 35 40070 7748300 Nick 7748300 Nick 40 40141 Sam 40 40141 8579674 Sam 8579674 Sam 27 40116 Ram 40 40116 8579958 Ram 8579958 Ram 28 40069 chrsty 40 40069 8641880 chrsty 8641880 chesty 44 40006 Carrie 0 40006 8641881 Carrie 8641881 Carrie 0 40034 Nick2 36 8641883 Kirsten 8641883 Kirsten 40 40083 Sam1 40 40034 8641885 Nick2 8641885 Nick2 40 40023 Ram1 40 40083 8641890 Sam1 8641890 Sam1 40 40126 chrsty1 35 40023 8641896 Ram1 8641896 Ram1 40 40133 Carrie2 42 40126 8641900 chrsty1 8641900 chrsty1 40 40096 kisrsten1 36 40133 8641902 Carrie2 8641902 Carrie2 42 40036 Nick1 40 40096 8641903 kisrsten1 8641903 kisrsten1 36 40036 8641906 Nick1 8641906 Nick1 36 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.
