Senior |
|
Joined: Tue Jan 11, 2005 5:03 pm Posts: 137 Location: Montreal, Quebec
|
I hope I understand you well.
You say a User (you need a table named User to keep them) can have many Items (you need a table Item).
If a items can be keep by only one User, you need a one-to-many relationship between them. A user (One) can have many (to-many) Items.
Or if a Item can be under (keeps by) many Users, then you need a many-to-many relationship (you need a UserItem table).
Regards,
Etienne.
Rate the post if it helped!
|
|