I'm using ISM 2017.3
We are in a somewhat unique situation where we have multiple agencies in our building using one HR department. We are looking at creating some HR processes that will cover the agencies in the building. I've created and Agency business object and created my agencies there. The OOTB already has Department business objects. I want to link the agencies to the departments. An agency will have many of the same department names, one such example bing HR will exist across all agencies. IT would be another Department name that all agencies will have. So to me it seems I have a Many-to-Many relationship - an agency can be associated to many departments, and a department can be associated to many agencies. When I create a Department, I want to pick the various agencies to which it will belong. Here's my approach...
I created an Agency business object
- created a Name field to hold the agency name
- autogenerated the UI
Then I created my agencies.
Next, I created an Agencies pick list pulling the names from my Agency business object as the values.
Next, on my Department object
- created an AgencyLink field
- created a relationship AgencyAssocDepartment
- created an AgencyName text field
- used pick list Agencies from above
- modified Department form to use this new AgencyName field
- modified control properties of this field to Radio Button
Now, when I create a new Department all my agencies show in the form, but I can only pick one. I fear I don't fully understand relationship building and link fields. The link field holds the association value between the Department and the Agency. The relationship defines the type of relationship and to what object. But I don't see how the department's AgencyLink link field will hold the multiple Agency values. It probably doesn't and I'm really missing a key element here.
Hopefully someone can show me the way.