Folks
I'm wondering whether it's possible, instead of embedding a subdatasheet, to list all values that would otherwise appear in a subdatasheet in one cell in the main query.
The scenario is this. I'm creating a database of documents 99.9% of which have only one author. But because 0.1% have more than one author, I have a separate authors table that stands in a many-one relationship to my documents table. I need to display authors in my documents query, but because so few have more than one author a subdatasheet is an undesirable complication. That's why I'd like, if possible, to list authors in one cell. Is such a thing possible?
Thanks
Remster