UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Table Relationships, Office 2007    
 
   
enrico
post 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?
Go to the top of the page
 
+
Bob G
post 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 ?

Go to the top of the page
 
+
argeedblu
post 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 the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 10:38 AM