Forum Discussion
Solved
Problem with unique values
I have a table of shipments statistics 'Query 1', and a table with distances from our warehouse based on postnumbers 'Rev 202011'. I'm trying to create a relationship between the postnumbers ('query...
Hi Dhjlm ,
In addition to what Greg_Deckler mentioned in his response, do check if there are NULL values in the columns that you are trying to create relationship on. ('query1[POSTNR3] and 'Rev 202011'[Postnr] in your case)
I have experienced similar error in the past due to the NULL values in the key columns that are used for creating the relationships between two tables.
Thanks,
Pragati
Dhjlm , when you getting this, while creating or when change it to many to one. ?
looking at this screenshot difficult to tell