4 Replies Latest reply: Mar 29, 2017 9:51 AM by Sunny Talwar RSS

    Getfieldselections in alternate state table

    Dennis Kohl

      Hi,

       

      I've set a table to alternate state and want to get in that table the selections from a mainstate table. I've tried the following formulas. But they don't work.

       

      GetFieldSelections([Field],',',100000)

      GetFieldSelections([Main State]::[Field],',',100000)

      GetFieldSelections([Field],',',100000,'Main State')

      Concat([Field],',')

      Concat([Main State]::[Field],',')

      Concat([Field],',','Main State')

       

      If I set the selection box also to an alternate state like "State A". The following formula works.

      GetFieldSelections([Field],',',100000,'State A')

       

      So it only doesn't work with main state.

       

      Could you please help me with it?

       

      Thanks a lot in advance.