Want to apply selection from one field to another similar field

[#1]

I have a scenario where I have an integrated data model with 50+ tables. And I have one unrelated table, call it a data island.

In the integrated model I have columns like

Gender

Disability,

etc....

This data island has similar columns but with different names.

Gender_Sector

Disability_Sector

I've got list boxes for Gender, Disability.... Whatever selection I make in these fields I need to apply in the data island as well.

e.g. If 'Male' is selected in the 'Gender' listbox, I need to effect that selection in the field 'Gender_Sector'. Can anybody think of a solution? I am trying a few things not reaching where I want to.

Thanks,

Ram

[tresesco]

Use Field Selection trigger. Like for Gender field selection - trigger-> select in field Gender_Sector->Search String: GetFieldSelection(Gender)

PFA

[#3]

Thanks tresesco. Looks like a perfect solution. I’ll try this now. Need to do few modifications to all three layers. ☺

[#4]

Hi Tresesco, Everything seemed work perfectly until I did a multiple selection. You can check in your example if you select both 'Male' and 'Female', it doesn't work. Can you kindly check?

Thanks,

Ram

[sarvjeet]

use getfieldselections(Gender) - Returns a string with the current selections in a field.

[#6]

it is actually GetFieldSelections...   Doesn't work....

[jagan]

Hi Ram,

You have to form the selected values in this format and then use this in Search String:

(Male|Female)

Regards,

Jagan.

[jagan · Accepted solution]

Hi Ram,

Try like this

Gender field selection - trigger-> select in field Gender_Sector->Search String:

='(' & GetFieldSelections(Gender, '|') & ')'

Regards,

Jagan.

[#9]

Hi Jagan, This doesn't work if the value has a space in it.

[jagan]

Hi Ram,

If you have spaces in values then try like this

='("' & GetFieldSelections(Gender, '"|"') & '")'

Regards,

Jagan.