Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 679
  • Last Modified:

Data table relation with two different data types

Trying to add a relation for two different data tables that the releated columns have different data types.

Both columns have the name of screen_no but one table is Int16 and the other is Int32.
I am getting the error "Parent Columns and Child Columns don't have type-matching columns"

Thanks,
0
DowntownIT
Asked:
DowntownIT
  • 3
1 Solution
 
Anurag ThakurTechnical ManagerCommented:
wont work
even sql server does not allow that
promote int 16 column to int 32 because in that way you wont be loosing anything
0
 
DowntownITAuthor Commented:
Thanks raqi, unfortunately I don't have control of the source of the columns but can change anything in the data table(s) as needed and that is where I am getting hung up. Don't know the best approach to doing that.

Thanks again,
0
 
DowntownITAuthor Commented:
I was able to do something completely different and bypassed this issue all together.
0
 
DowntownITAuthor Commented:
Went in a different direction
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now