 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Relationship Links
How come when I link my tables in the relationship window, I never the "zeros" that show you the many side and the "1" for the one side. I see this in other examples but not my Access 2007. I use to see it in Access 97 etc but not this version. Is thiera way I can set this feature to turn on? II do see it says one to many but not the actual 1's and 00's. Why is this? > How come when I link my tables in the relationship window, I never the > "zeros" that show you the many side and the "1" for the one side. I see [quoted text clipped - 3 lines] > do > see it says one to many but not the actual 1's and 00's. Why is this? Those symbols are shown only when the option 'Enforce referential integrity' is selected. It appears that this option is no longer selected by default when you create a new relationship, as it was in previous versions). If you right-click on the line between the two tables in the Relationships window and choose 'Edit relationship' from the shortcut menu, you can turn on that option, and the symbols will become visible.  SignatureBrendan Reynolds >> How come when I link my tables in the relationship window, I never the >> "zeros" that show you the many side and the "1" for the one side. I see [quoted text clipped - 13 lines] > window and choose 'Edit relationship' from the shortcut menu, you can turn > on that option, and the symbols will become visible. Hmm. Well I *thought* it was selected by default in previous versions. I just checked on another PC that has Access 2000 installed, and the option doesn't seem to be selected by default in that version either. If there is an option to change the default behaviour, I haven't been able to find it yet. SignatureBrendan Reynolds Thank you very much. perfect! > >> How come when I link my tables in the relationship window, I never the > >> "zeros" that show you the many side and the "1" for the one side. I see [quoted text clipped - 19 lines] > an option to change the default behaviour, I haven't been able to find it > yet. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.