• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Juggling Multiple Relationships

You've defined relationships between two or more tables, but when you open the Query window to edit an existing query, Access doesn't connect the tables with lines. What's wrong?

The Relationships window enables you to define default relationships between tables. When you create a new query, Access picks up those settings and uses them. Changing the default relationship in the Relationships window has no effect on existing objects, such as queries; likewise, you can change the relationship between two tables in a query without affecting the default relationship. Re-create the relationship in the Query window so that it matches the default relationship for the two tables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint