Multiple Locations in a form

[snowuser111]

Hi Experts,

I want to create a related list for locations so that we can select multiple locations. Can anyone help me suggesting this please.

Thanks

[Chuck Tomasi · Accepted solution]

It sounds like you want the many-to-many functionality based on your earlier requirement. - The ability to add multiple locations to a CI, and use those locations on multiple CIs (not exclusive to one.) Putting a field on the cmn_location won't get you where want to go. It was a simple example how to relate two records together. Here's what you'll need to do:

1. Create a new table (e.x: CI Location [u_ci_location])
2. Add two fields to the new table
   1. CI [u_ci] - reference field to table cmdb_ci
   2. Location [u_location] - reference to table cmn_location
3. Add the related list to your CI form(s) and it will show locations
4. (optional) Add the related list to your Location table, and it will show CIs

Hope that helps

[cwilker10]

Alternatively, you could look into a GlideList on the Change form that references the Location table.   Not quite as elegant as the Related List, but just something to investigate.

[sgrison]

I would agree with cwilker - glidelist would be the easiest/quickest solution but it really depends on what you will be doing with this data..

[snowuser111]

I just want a option in the change form so that I can select more than one location.

Thanks

[snowuser111]

Resolved. Thanks all for help.