I have two tables:
Table 1 has a fields Description, Item_num, Indx_num
Table 2 has Memo, Item_num, Indx_num
I want to combine (concatenate?) all the Description records from Table 1 and put them into a memo field in Table 2 then replace Item_num and Indx_num in table 2 with the corresponding values from table 1.
Here is a visual of what I want.
Table 1
Descr. Item Num Indx
---------------------------
red 1 1
---------------------------
cold 1 1
---------------------------
old 1 1
---------------------------
blue 2 2
---------------------------
warm 2 2
---------------------------
young 2 2
---------------------------
white 3 3
---------------------------
hot 3 3
---------------------------
new 3 3
---------------------------
Table 2
memo Item Indx
---------------------------
red 1 1
cold
old
---------------------------
blue 2 2
warm
young
---------------------------
white 3 3
hot
new
---------------------------
(I intended the dotted lines to indicate seperate records Index and Item are not always the same. )
Thanks in Advance
Tom
Table 1 has a fields Description, Item_num, Indx_num
Table 2 has Memo, Item_num, Indx_num
I want to combine (concatenate?) all the Description records from Table 1 and put them into a memo field in Table 2 then replace Item_num and Indx_num in table 2 with the corresponding values from table 1.
Here is a visual of what I want.
Table 1
Descr. Item Num Indx
---------------------------
red 1 1
---------------------------
cold 1 1
---------------------------
old 1 1
---------------------------
blue 2 2
---------------------------
warm 2 2
---------------------------
young 2 2
---------------------------
white 3 3
---------------------------
hot 3 3
---------------------------
new 3 3
---------------------------
Table 2
memo Item Indx
---------------------------
red 1 1
cold
old
---------------------------
blue 2 2
warm
young
---------------------------
white 3 3
hot
new
---------------------------
(I intended the dotted lines to indicate seperate records Index and Item are not always the same. )
Thanks in Advance
Tom