One to Many Tables/ Relationships

Sometimes it is useful to setup a relationship between an asset and multiple children. A good exampe of that might be a comments table on an asset that might contain extra metadata such as approval history.

Steps to setup a relationship are:

1. Create a new module called Comments

Add Module: http://demo.entermediasoftware.com/emshare/views/settings/modules/setup/index.html
Name: Asset Comments
Id: assetcomment

2. Create an editing box called General, add fields such as Name, notes etc. Make sure you create a field called assetid. That will be used to join the asset and assetcomment tables.

3. Open asset settings area | Views | http://demo.entermediasoftware.com/emshare/views/settings/modules/asset/metadata/views/index.html

4. Add a view such as Comments

5. Look on the right side of the View editor. There is a round gear. Use that to open the advanced settings:

OnetoMany_table

6. Now the Asset Detail Editor will have a new Comments box with a one to many relationship in it.