I have just been given a task of creating reports for a new database and have run into an issue. It may be an easy one but I am not understanding what is wrong. In my data model i have a sales orders table and a stock table which describes our products etc. However, when i try to create a relationship between the stock codes in each table i am given an error as seen in the photo. I have checked and removed for duplicates as well as nulls and blanks yet still get the error. Any idea what could be causing this issue? I didn’t want to do a bad work around since its a pretty base/ major thing to set up right.
Part of my data model
Data - the stock codes do match just maybe not many in this photo shown
Cheers for any suggestions,