2 Replies Latest reply on Feb 4, 2016 8:39 AM by beverly

    How to split up a large value list and migrate the data?

    jemiljan

      I have one value list that is very large. Since I am now forced to convert a multiple-selection pop-up menus in an older database to checkbox sets, it takes up too much space. So I want to split this one very large value list into 4 shorter lists, but retain the data entered.


      To save space on the form, I found that using a tabbed menu design will help me to divide up the data but not take up too much space on the form. I want to migrate the existing data into each of the four value lists onto each tab. Basically, I want to migrate the existing data in value list A to the new value lists B, C, D, and E. All of the values will be the same. I suspect that there is a way to either use a function or Replace Field Contents to do this?

       

      Any hints?

       

      Thanks!