Getfieldselections in alternate state table

[#1]

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.

[sunny_talwar]

When you say main, do you mean default or inherited state? May be try this:

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

[vinieme12]

We don't need to specify a state for the default state just use

=GetfieldSelections(Fieldname)

[sunny_talwar]

I thought so too, but it seems that this did not work for him

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

So, might make sense to include the state

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

[sunny_talwar]

Here is a sample attached