Want to apply selection from one field to another similar field
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
This data island has similar columns but with different names.
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.