Forum Discussion
Duplicate value not allowed, many to many
- 8 years ago
vazperen you will need to create a distinct list of horses, you cannot do many to many directly, there has to be a unique lookup table in the middle, get a distinct list of the horse column and place it between the tables you have remapping the relationship.
do you need a many to many relatioship? where are you filtering the data from in your visuals, you shouln'dt use the both option unless you know how it works
vazperen you will need to create a distinct list of horses, you cannot do many to many directly, there has to be a unique lookup table in the middle, get a distinct list of the horse column and place it between the tables you have remapping the relationship.
do you need a many to many relatioship? where are you filtering the data from in your visuals, you shouln'dt use the both option unless you know how it works
Yes, that's what I thought...thanks!