Table Relationships Do NOT display

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ChristianC
    New Member
    • Aug 2006
    • 10

    Table Relationships Do NOT display

    I'm getting started developing a new database and I've established my tables and I made a few relationships. Now I'm trying to make some changes which involve deleting a few columns in one table that happen to be tied to another table. For some reason when I go to the relationships window it displays the two tables I haved tied, but does not show the relationships and every time I attempt to delete the column in one of the tables, it tells me that I cannot do that until I delete the relationship. Has anyone encountered this problem? Any advice?
  • Jim Doherty
    Recognized Expert Contributor
    • Aug 2007
    • 897

    #2
    Originally posted by ChristianC
    I'm getting started developing a new database and I've established my tables and I made a few relationships. Now I'm trying to make some changes which involve deleting a few columns in one table that happen to be tied to another table. For some reason when I go to the relationships window it displays the two tables I haved tied, but does not show the relationships and every time I attempt to delete the column in one of the tables, it tells me that I cannot do that until I delete the relationship. Has anyone encountered this problem? Any advice?
    1) If you have defined your relationships and Access simply isn't showing them then try the menubar .....Relationsh ips .....show all

    2) if 1) doesnt work try menubar...Edit. ..clear all then repeat 1)

    Jim :)

    Comment

    Working...