10 Replies Latest reply: Jun 11, 2014 9:35 PM by Ramkumar Ramagopalan RSS

    Want to apply selection from one field to another similar field

    Ramkumar Ramagopalan

      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