culann.com

Sorting problem

So I’ve got a problem with the application I’m working on now - I’ve got a recordset that I need to sort. It’s got a number of fields, including one called userID. Unsurprisingly, userID represents a person (one who usually has a first and last name). The name of the person represented by userID, however, doesn’t live in the same database that my recordset is being pulled from, so I can’t retrieve it with a JOIN operation.

Here’s my question, then: how can I sort a recordset by a field it shares with another recordset?

—

Figured it out - I created a disconnected recordset sorted by the name and populated it with all the original data PLUS the user’s name (which I looked up on the fly while populating the new RS). Ouch, my head hurts.