Last post May 07, 2007 12:43 PM by justlearningasp
May 02, 2007 05:22 PM|justlearningasp|LINK
This is my first time creating a website.
I would like to create one to one relationships in the PS Kit by editing the original Database of Albums and Photos.
Is this Possible?
If it is. Can you direct me to a tutorial or guide me through the process of creating one to one relationships.
What I want is that each time a user logs on and creates a username and password. A new table/tables is created that consists of user balance, user add funds, user withdraw funds, user transaction history. These table should contain information for one user
This information will be entered manually into db by an admin user that has the only access to insert, edit and delete in the database.
I used the website admin tool to create 2 users but I am learning about sql express as we speak from the video tutorials of this site.
But I have not come across how to create a one to one relationship and not one to many.
Please help me?
May 03, 2007 03:28 AM|Mikesdotnetting|LINK
If you really want to create a one-to-one relationship, add a new table and use the User ID as a primary key.
But your design is faulty. And you are not creating a one-to-one relationship either. Each table you propose to create will have many transactions belonging to one user. That's a one-to-many relationship. Finally, you shouldn't create a separate transaction
table for each user, you should put all transactions for all users in one table, and link to the userID in the users table.
Any time you are thinking of creaing a one-to-one relationship, alarm bells should ring. 99% of the time, it suggests your thinking or design is wrong.
May 07, 2007 12:43 PM|justlearningasp|LINK
Thanks I will do one to many relationships instead.