Forum Discussion
Problem creating unique values to create a relationship
Hi I'm trying to join two tables together through a relationship but am having trouble. My data is of a Building (type text) , which has Floors and Rooms which can both be a mix of text a...
You have case sensitive in Room on Room_UniqueValues. and have null as well.
Action to be take
Change into Lower or Upper case. and remove null.
Hope youn have blank in Room_UniqueVales table. Try to remove blank and try the relationship.
Hi, thanks for quick reply. I had a go at removing blanks and joining the tables again, but I get the same error message.