6 Replies Latest reply: Oct 5, 2011 6:17 AM by ulrikevet RSS

    Splitting a field depending on a field in a second table

      I have two tables

      One with the make  of cars (eg Volkswagen, Alfa Romeo) and the other with Models in the form of Volkswagen Polo, Alfa Romeo Guilietta.

       

      I want a key on 'Make', but don't know how to split the make and model in the second table.

       

      Using SUBFIELD works, but only for one word Makes.

       

      Has someone an idea.