Relationship Links

[TKM]

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?

 

[Brendan 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
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?

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.

 

[Brendan Reynolds]

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.

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.

 

[TKM]

Thank you very much. perfect!

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.