K2 BLACKPEARL PRODUCT DOCUMENTATION: USER GUIDE
SmartObject Relationships
Designers > K2 Studio > Access > Understanding SmartObjects and Service Objects > SmartObject Relationships Send feedback

K2 SmartObject Relationships

Relationships are configured between SmartObjects using the SmartObject Association Wizard. Running the wizard creates the foreign keys between the SmartObject tables enabling the association between SmartObjects. Data is returned from the SmartObject tables when reports are created and run. The available relationships are as follows: 

One to One

In a One to One relationship the Foreign key is created in the parent SmartObject as shown below.

One to One relationship 

One to Many

In a One to Many relationship the Foreign key is created in the Parent SmartObject as shown below:

One to Many relationship 

Many to One

In a Many to One relationship the Foreign key is created in the Child SmartObject as shown below:

Many to One relationship 

Many to Many

In a Many to many relationship a new SmartObject is created and contain a Foreign key from each of the linking SmartObjects as shown below:

Many to Many relationship

In K2 blackpearl extra SmartObject properties can be added to the new SmartObject as shown below with the Teacher ID:

  

See Also
SmartObject Association Wizard - Association Details

 

 

K2 blackpearl Help 4.6.10 (4.12060.1690.0)