Hi Jasper,
As you know, I'm no expert on this kind of thing, but it seems like you could accomplish this with a well-written global. The one you and Jai helped me out with in this thread: http://www.gossamer-threads.com/...orum.cgi?post=223071 is an example of one that loops through related records in a foreign table and outputs information. Couldn't you do the same kind of thing here?
Also, I haven't quite figured out how to work with DBMan SQL's new query features, but it seems like this kind of problem might be what they're designed to handle.
Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund
As you know, I'm no expert on this kind of thing, but it seems like you could accomplish this with a well-written global. The one you and Jai helped me out with in this thread: http://www.gossamer-threads.com/...orum.cgi?post=223071 is an example of one that loops through related records in a foreign table and outputs information. Couldn't you do the same kind of thing here?
Also, I haven't quite figured out how to work with DBMan SQL's new query features, but it seems like this kind of problem might be what they're designed to handle.
Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund