A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Relationship layout does not show joins.



 
 
Thread Tools Display Modes
  #1  
Old November 15th, 2004, 06:37 PM
NLM
external usenet poster
 
Posts: n/a
Default Relationship layout does not show joins.

When I save a relationship layout and close the window, when I come back the
tables are in the same places, but the joins do not show up. When I open up
Northwids, it saves the relationships no problem. Just my database for some
reason does not store them. Is there a setting I am missing somewhere?
  #2  
Old November 16th, 2004, 02:15 AM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Mon, 15 Nov 2004 10:37:04 -0800, NLM
wrote:

When I save a relationship layout and close the window, when I come back the
tables are in the same places, but the joins do not show up. When I open up
Northwids, it saves the relationships no problem. Just my database for some
reason does not store them. Is there a setting I am missing somewhere?


I've found that the relationships window can be VERY flaky and
error-prone; this is just one of several annoying symptoms. Try
clicking the "View All" icon (this may or may not help); also try
compacting the database.

If this doesn't help: Try clearing the form, selecting a table, and
clicking the "View Direct" icon. Do lines show up now?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
  #3  
Old November 16th, 2004, 02:00 PM
NLM
external usenet poster
 
Posts: n/a
Default

Thanks, I just tried your suggestions, the Show Direct worked briefly, but
when I save and exit and come back they are all gone again. This is weird,
esspecially because it does not do it in the Northwids database.

"John Vinson" wrote:

On Mon, 15 Nov 2004 10:37:04 -0800, NLM
wrote:

When I save a relationship layout and close the window, when I come back the
tables are in the same places, but the joins do not show up. When I open up
Northwids, it saves the relationships no problem. Just my database for some
reason does not store them. Is there a setting I am missing somewhere?


I've found that the relationships window can be VERY flaky and
error-prone; this is just one of several annoying symptoms. Try
clicking the "View All" icon (this may or may not help); also try
compacting the database.

If this doesn't help: Try clearing the form, selecting a table, and
clicking the "View Direct" icon. Do lines show up now?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Play music while slide show is going - keep slide show going duri. sarahangela New Users 2 October 12th, 2004 12:29 AM
disable Show in Groups Deckard General Discussion 1 September 1st, 2004 01:49 PM
Not seeing all relationships in layout window jettabug General Discussion 3 June 18th, 2004 05:42 PM
Word View Changes from Print Layout to Web Layout on Opening html docs Dawn Page Layout 0 May 6th, 2004 03:39 PM


All times are GMT +1. The time now is 10:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.