I have an app for project managers. When they create an activity, they can assign that activity to a project team member or other resource. The
Assigned To field in the
Activities table is a multi-select text field. The
Assigned To field is pulling from the
Resource Name field in the
Resources table. As project managers identify new resources, they can add those resources to the
Resources table. The problem now is the
Resources table has 118 resources. The
Assigned To field, being a multi-select text field, can only handle 100 maximum entries (I didn't know that when I set up the field. Argh!). So, now I can't edit that field, because when I do, I get this error:
Choices too long. 118 choices specified. Field may not have more than 100 choices. And over time, we're going to have more than that.
My research shows I should have created a one-to-many relationship between the
Activities and
Resources tables and use the reference field as the source for the dropdown. So, I did that. The problem is I can only select one resource. We need to be able to select multiple resources that will work on that activity, hence why we originally set it up as a multi-select text field.
Ideas anyone?? Thank you, in advance, for your help and consideration!
------------------------------
Tom
------------------------------