Forum Discussion
Establishing Relationship
You can't create a relationshipship between the columns that doesn't have unique values atleast either of one. In this case I will try to bring in unique values in atleast one in either of the columns or I would build a Bridge table in between these two tables which contains only the unique values of the Joing column then you can create a relationship like this lefttable(* -1) Bridge table (1-*)Righttable.
You can't create a relationshipship between the columns that doesn't have unique values atleast either of one. In this case I will try to bring in unique values in atleast one in either of the columns or I would build a Bridge table in between these two tables which contains only the unique values of the Joing column then you can create a relationship like this lefttable(* -1) Bridge table (1-*)Righttable.
Anonymous you are exactly right. I actually JUST figured it out a few moments ago. Thank you!