show table relationships

drstein

Registered User.
Local time
Today, 13:15
Joined
Mar 23, 2009
Messages
28
In a graphical display, I would like know how to show the relationship between 4 new tables in an access 2007 database. I know that I setup this relationship since in the past but I can not get the 'arrows' to show up in the graph. i looked at the following link for assistance, but this does not show the graphically relationship between the table:
http://office.microsoft.com/en-us/a...-relationships-HA010120534.aspx#_Toc269752117.

i also clicked on each table to look their properties, and nothing is marked as 'hidden'
 
Arrows... do you mean how to show the one-to-many relationship? Double-click the solid line (#2 in the image in your link) and change the relationship type. That should do it.
 
What you recommended does not work ofr me yet. What I did was to drag some tables to the design surface and I wanted to show the relationship between the 4 tables. Yesterday I had a design option from the menu bar and now that design option does not display. That is how I was able to drag the tables onto the design suraface.
 
What you recommended does not work ofr me yet. What I did was to drag some tables to the design surface and I wanted to show the relationship between the 4 tables. Yesterday I had a design option from the menu bar and now that design option does not display. That is how I was able to drag the tables onto the design suraface.


Check out this video: http://www.youtube.com/watch?v=4e6Y003KQdo.
Also this one, starting at the 2:00 mark: http://www.ehow.co.uk/video_4801732_define-between-microsoft-access-tables.html
 

Users who are viewing this thread

Back
Top Bottom