Access 2007 Inside Out, Page 187

S

Stan_Pearse

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.
 
R

RoyVidar

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.
 
K

Ken Snell \(MVP\)

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.
 
J

Jeff Conrad [MSFT]

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
 
Top