sql server Foreign Key to a GUID
Posted on 2014-09-12
I have two tables, tblpeople and tbladdresses. Both have a PersonID, in tblpeople that id is a Primary Key data type GUID. In the tbladdresses it is a varchar, but has the same info from tblpeople but there are duplicates due to multiple addresses. I am trying to get a foreign key reference but it is complaining about the data type issue. What is the best way to fix this?