How would I make one field get ffilled wiht multiple calues?
I want the contents of Table1.Column2 and Table1.Column3 in Table2.Column2.
All fields are character fields.

TABLE LAYOUT:
Table1:
Column1 Column2 Column3
T001 L001 TEXT1
T002 L001 TEXT2
T003 L001 TEXT3
T004 L001 TEXT4
T005 L002 TEXT5
T006 L003 TEXT6
T007 L003 TEXT7
T008 L004 TEXT8
T009 L004 TEXT9

Table2:
Column1 Column2
L001 TEXT1, TEXT2, TEXT3, TEXT4
L002 TEXT5
L003 TEXT6, TEXT7
L004 TEXT8, TEXT9

VALUE WANTED in Table2.Column2
T001
TEXT1

T002
TEXT2

T003
TEXT3

T004
TEXT4