My Assistant
![]() ![]() |
|
|
Apr 11 2012, 07:00 AM
Post
#1
|
|
|
UtterAccess Addict Posts: 211 |
i created two tables (namely: "table user1" and "table properties") with a one-to-many relationship, respectively. if i want to add two other tables namely "table user2" and "table user3", will it create a problem if i'll also connect it to "table properties" having the same quality with the former?
|
|
|
|
Apr 11 2012, 07:08 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 8,104 From: CT |
why would you want to have a table for each user ?
|
|
|
|
Apr 11 2012, 08:20 AM
Post
#3
|
|
|
UA Forum + Wiki Administrator Posts: 11,944 From: Sudbury, Ontario, Canada |
As Bob has suggested, you should not have more than one user table. If the properties table contains properties that refer to the users, then you would have a field in the properties table for userid and create a relationship between the user primary key and the properties user id field.
Glenn |
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 18th May 2013 - 10:38 AM |