Smartforms: Using List Display control in a table

  • 30 June 2014
  • 1 reply
  • 0 views

Badge +1

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


1 reply

Badge +7

Here is a link describing composite SmO basics.


http://old.k2underground.com/blogs/fromthebench/archive/2008/02/13/composite-smartobject-basics.aspx


 


Here is another link describing composite SmO's in a many-to-many relationship


http://help.k2.com/KB001304#


 



Maybe one of those links will help you.  You need to find a way to combine the SmO's and then put them in the list control.


 


 

Reply