Hi all,
I have the following requirement:
I have a SmartObject containing document metadata, e.g.
[DocumentSO]:
DocID
DocName
DocType
Then I have another SmartObject containing a list of document owners, e.g.
[DocumentOwnerSO]:
OwnerID
OwnerName
DocID
Each document can have multiple owners, i.e. multiple entries with the same DocID in the [DocumentOwnerSO] table.
Now I would like to create a listview table on the [DocumentSO] where for each document I also display all the owners, e.g. something like:
[DocName] [DocType] [OwnerName]
Document1 pdf Name1
Name2
Document2 pdf Name1
The trick here is to show a list of owners for a single row in the [DocumentSO] table. I have tried to user the List Display control in one table columns and setting the datasource to the [DocumentOwnerSO] - and creating association between the two based on the DocID property - but I have not been able to figure out how this should be configured.
Does anyone know if and how this can be done?
Thanks,
Anders