I am just wondering how this works exactly. I've searched both this site and Google and I haven't found much information about this. I am specifically talking about the sort option in the Relationships section of the database:
I have played around a bit with this, but I have run into situations where if I specify a sort order, if I make a layout with the same TO, the records aren't sorted as specified. Would this sorting work with an x-join? What are the limitations and advantages of this?