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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Establishing a 1-to-1 between Two Tables

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
Go to Top of Page
   

- Advertisement -