2 Replies Latest reply: Mar 7, 2016 4:03 AM by Oliver Krause RSS

    Use of reference table with comma-separated-values in one field

    Oliver Krause

      Dear all,

       

      I have the following issue: I read a reference table:

       

      Referencetable

      ECU

      Car

      MIL01

      Cabrio2015,SUV2017,SUV2018

      Huentry

      Cabrio2015

      HuentryPLUS

      SUV2017

      HUnextGen

      SUV2018,Cabrio2021, Limo2018

      LHZ02

      Cabrio2015,Cabrio2021

       

      And I have a list of Cartypes and Cars

      CarList

      Cartype

      Car

      Cabrio

      Cabrio2015

      Cabrio

      Cabrio2021

      SUV

      SUV2017

      SUV

      SUB2018

      Limo

      Limo2018

       

       

      When I now select (by clicking) in CarList a Cartype (e.g. "Cabrio") and want to get relevant ECUs for this cartype (in this case: MIL01, Huentry, HUnextGen, LHZ02).

       

      Any idea how to do this?

       

      Thanks

      Oliver