Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking order

Status
Not open for further replies.
Mack2

Mack2

Instructor
Mar 12, 2003
336
US
Within the relationships window, if you have 10 tables and they are all linked, what relationship does access look at first for returning records? Mostly concerning when the join types are different for each relationship.....THANKS
 
Sort by date Sort by votes
It's entirely dependent on the ORDER BY clause in your SQL statement. Otherwise, there's no way to predict what the order will be.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Linking to outlook email - how to get reply to address
Replies
1
Views
217
sxschech
sxschech
CharlieT302
  • Locked
  • Question
Linking to a Workgroup Information File
Replies
1
Views
94
lameid
lameid
blueman124
  • Locked
  • Question
Linking to image in sharepoint
Replies
2
Views
99
strongm
strongm
weightinwildcat
  • Locked
  • Question
Couting Line Items per Order Number in a query
Replies
2
Views
90
dhookom
dhookom
Bill6868
  • Locked
  • Question
Seeking Cautionary Advice Re Linking Tables From Another Software Program
Replies
2
Views
114
madonnac
madonnac

Part and Inventory Search

Sponsor

Back
Top