Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sativez
Starting Member
1 Post |
 Posted - 2015-02-21 : 23:33:19
|
| Hello Everyone,I would like to first thank you for the opportunity given in this forum for asking questions and learning. I have been learning SQL server for since late December 2014, I learned first with Access so to acquire relational database background.I have two tables, one created manually (StoreProfile={StoreID,StoreName, StoreAddress, State, ZipCode, Phone}) and the other one being dbo.aspnet_User from the SqlMembership provider, e.g.,UserID, UserName, loweredUserName, MobileAlias, IsAnonymous, LastActivityData.Given, what I am looking to do is to implement a 1-to-1 relationship between the primary of the StoreProfile(StoreID) and that of dbo.aspnet_User(UserID). Both primary keys are of the same data type, using the database diagram for linking the tables result in creating a 1-to-many relationship.I did not find or perhaps overlook useful guidance on Microsoft's Developer Network on how this can be done, would you help me to solve this problem.Thank you so much for your help.georgesdbengo |
|
|
huangchen
Starting Member
37 Posts |
Posted - 2015-04-02 : 05:58:08
|
| unspammed |
 |
|
|
|
|
|
|
|
Establishing a 1-to-1 between Two Tables