I'm creating a report model (2008 R2). I am trying to create a relationship between two tables. One FKs to another--same name and type (tinyint) columns. But the Data Source View editor doesn't allow this, giving the message "...source
and destination column have different data types". But the columns are the same types. I ahd this once before acouple of years ago and don't remember how I got around it.
Does anyong have ideas?
View Complete Post