Access 2007 Inside Out, Page 187

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On page 187 of MS Access 2007 Inside Out the author is not very clear in the
second paragraph , "Note that once you define a relationship, yo can delete
the table or query field lists from the Relationhips windo without affecting
the relationships. [To do this, click the table or query list header (??) and
press the Delete key]."

Can someone please help me understand what the author is tring to convey?

Thanks.
 
Stan_Pearse said:
On page 187 of MS Access 2007 Inside Out the author is not very clear in the
second paragraph , "Note that once you define a relationship, yo can delete
the table or query field lists from the Relationhips windo without affecting
the relationships. [To do this, click the table or query list header (??) and
press the Delete key]."

Can someone please help me understand what the author is tring to convey?

Thanks.
Click to expand...

The relationship window is a visual representation of the relationships.
Actually, when we do some drag'n and dropping, what happens between the
scenes, is something like

ALTER TABLE tblShipping
ADD CONSTRAINT FK_tblShipping
FOREIGN KEY (CustomerID) REFERENCES
tblCustomers (CustomerID)

which wont go away if you remove the visual representation of the table
in the relationship window.

To actually remove the relationship through the interface, you'd need
to right click the line representing the relationship, then select
"Delete".

Just try it out. "Delete" some of the tables or queries according to the
description, then find the "Show All" or "All Relationships" button, and
automagically, they're back.
 
The tables that you see in the Relationship window are just representations
of the relationships that you wish to display at that time. If you set up a
relationship between two tables in that window, and then click on one of the
tables and press Delete key, you just removing the image of the table in the
window, you're not deleting the table and you're not deleting the
relationship between that table and the other table. The only way to delete
a relationship is to have both tables showing in the Relationships window
(add the "deleted" table image back using the "table add" icon button on the
toolbar), click on the join line, right-click and select Delete menu item.
 
Stan,

What we're saying is that you can remove tables from the grid itself, but
not remove the saved relationships. If the window is becoming too cluttered
and/or you want to focus in on one specific area, you can safely remove the
tables from the window, but not destroy the relationships.

- If you select the join line between two tables and press the Delete key,
Access deletes the relationship between the two tables. (After prompting for
confirmation.)
- If you click the top of the table, or header as we call it, (the area that
lists the table name) Access removes the table from the grid. However,
Access does *not* delete any relationships between that table and related
tables.
- To re-display all established relationships, click the All Relationships
button in the Relationships group on the Relationships Tools Design
contextual tab. (say that three times fast...)

Does that help clairify things?
--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 
Thank you sir!

Your response greatly helped me to ferret that whole section out!
--
Stanley C. Pearse
Supervisor of Property and Distribution
Systems / Procurement Systems Analyst




Jeff Conrad said:
Stan,

What we're saying is that you can remove tables from the grid itself, but
not remove the saved relationships. If the window is becoming too cluttered
and/or you want to focus in on one specific area, you can safely remove the
tables from the window, but not destroy the relationships.

- If you select the join line between two tables and press the Delete key,
Access deletes the relationship between the two tables. (After prompting for
confirmation.)
- If you click the top of the table, or header as we call it, (the area that
lists the table name) Access removes the table from the grid. However,
Access does *not* delete any relationships between that table and related
tables.
- To re-display all established relationships, click the All Relationships
button in the Relationships group on the Relationships Tools Design
contextual tab. (say that three times fast...)

Does that help clairify things?
--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

in message:
On page 187 of MS Access 2007 Inside Out the author is not very clear in
the
second paragraph , "Note that once you define a relationship, yo can
delete
the table or query field lists from the Relationhips windo without
affecting
the relationships. [To do this, click the table or query list header (??)
and
press the Delete key]."

Can someone please help me understand what the author is tring to convey?
Click to expand...
Click to expand...
 
....oh one other thing...I have printed out your response and "stuffed it"
between pages 186 and 187.

Regarding the book...I wish the print was darker. The light print is really
bugging my eyes out where I have to get out a magnifying glass after a while.
--
Stanley C. Pearse
Supervisor of Property and Distribution
Systems / Procurement Systems Analyst




Jeff Conrad said:
Stan,

What we're saying is that you can remove tables from the grid itself, but
not remove the saved relationships. If the window is becoming too cluttered
and/or you want to focus in on one specific area, you can safely remove the
tables from the window, but not destroy the relationships.

- If you select the join line between two tables and press the Delete key,
Access deletes the relationship between the two tables. (After prompting for
confirmation.)
- If you click the top of the table, or header as we call it, (the area that
lists the table name) Access removes the table from the grid. However,
Access does *not* delete any relationships between that table and related
tables.
- To re-display all established relationships, click the All Relationships
button in the Relationships group on the Relationships Tools Design
contextual tab. (say that three times fast...)

Does that help clairify things?
--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

in message:
On page 187 of MS Access 2007 Inside Out the author is not very clear in
the
second paragraph , "Note that once you define a relationship, yo can
delete
the table or query field lists from the Relationhips windo without
affecting
the relationships. [To do this, click the table or query list header (??)
and
press the Delete key]."

Can someone please help me understand what the author is tring to convey?
Click to expand...
Click to expand...
 
Thanks.
--
Stanley C. Pearse
Supervisor of Property and Distribution
Systems / Procurement Systems Analyst




RoyVidar said:
Stan_Pearse said:
On page 187 of MS Access 2007 Inside Out the author is not very clear in the
second paragraph , "Note that once you define a relationship, yo can delete
the table or query field lists from the Relationhips windo without affecting
the relationships. [To do this, click the table or query list header (??) and
press the Delete key]."

Can someone please help me understand what the author is tring to convey?

Thanks.
Click to expand...

The relationship window is a visual representation of the relationships.
Actually, when we do some drag'n and dropping, what happens between the
scenes, is something like

ALTER TABLE tblShipping
ADD CONSTRAINT FK_tblShipping
FOREIGN KEY (CustomerID) REFERENCES
tblCustomers (CustomerID)

which wont go away if you remove the visual representation of the table
in the relationship window.

To actually remove the relationship through the interface, you'd need
to right click the line representing the relationship, then select
"Delete".

Just try it out. "Delete" some of the tables or queries according to the
description, then find the "Show All" or "All Relationships" button, and
automagically, they're back.
Click to expand...
 
Thanks Ken for the assist!
--
Stanley C. Pearse
Supervisor of Property and Distribution
Systems / Procurement Systems Analyst




Ken Snell (MVP) said:
The tables that you see in the Relationship window are just representations
of the relationships that you wish to display at that time. If you set up a
relationship between two tables in that window, and then click on one of the
tables and press Delete key, you just removing the image of the table in the
window, you're not deleting the table and you're not deleting the
relationship between that table and the other table. The only way to delete
a relationship is to have both tables showing in the Relationships window
(add the "deleted" table image back using the "table add" icon button on the
toolbar), click on the join line, right-click and select Delete menu item.

--

Ken Snell
<MS ACCESS MVP>


Stan_Pearse said:
On page 187 of MS Access 2007 Inside Out the author is not very clear in
the
second paragraph , "Note that once you define a relationship, yo can
delete
the table or query field lists from the Relationhips windo without
affecting
the relationships. [To do this, click the table or query list header (??)
and
press the Delete key]."

Can someone please help me understand what the author is tring to convey?

Thanks.
Click to expand...
Click to expand...
 
Glad we could help Stan.

I'll pass along your comments about the print quality to our publisher for
future reference. I think in this case the print is lighter because by the
time even one of the massive books was printed, the ink cartridge was
already worn out.
<g>

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 
Back
Top