Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combine records from one table into a memo field of another??

Status
Not open for further replies.

TomPose

Technical User
Dec 2, 2002
25
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top