>I am trying to copy the contents of the text field and memo field of one table into a new memo field of another table; e.g. the table "Scars" has two fields (location.txt & description.memo) I want to combine both fields into one memo field in the Names table (Names.scars). I have tried using copy memo & append memo but I end up with only one record(the first)being copied. What I want to do is combine and copy all the records from the scars table into the Names.scars field for each name that has scars listed in the scars table. If the name has more than one scar listed I want to combine the additional scars in the same memo field for that record. Can this be done (easily)?
>TIA
>--lincoln
Lincoln,
It could be done (concatanating & copying) but could you elaborate more the part that starts with "What I want ...". I couldn't understand how fields from one table would map to other. Is location linking field ? Does names.scars have something like location1, location2.. ?
replace scars ;
with scars.txt+chr(13)+chr(10)+;
scars.description ;
in "names"
Cetin