hard case with multivalued field

[radek225]

I have a two tables and I want to transfer data(from tblDolZleceniaZakonczone to tblDolZlecenia). In both cases, type of data are the same, except one. tblDolZlecenia.id_gora_zlecenia - is lookup multivalued field
Lookup:

SELECT [tblGoraZlecenia].[ID_gora_zlecenia], [tblGoraZlecenia].[Nazwa], [tblGoraZlecenia].[id_zlecenia] FROM tblGoraZlecenia ORDER BY [Nazwa];

but tblDolZleceniaZakonczone.id_gora_zlecenia is text:/.
relations:
[tblGoraZlecenia].[Nazwa] (part of it) = tblDolZleceniaZakonczone.id_gora_zlecenia.
and
tblGoraZlecenia.id_zlecenia = tblDolZleceniaZakonczone.id_zlecenia

e.g.
tblDolZleceniaZakonczone.id_gora_zlecenia "gwr;emc;tim" (text) after transfer shoudl be equal to [tblGoraZlecenia].[id_gora_zlecenia] where tblDolZleceniaZakonczone.id_zlecenia = [tblGoraZlecenia].[id_zlecenia] and part from tblDolZleceniaZakonczone.id_gora_zlecenia (...; ) equal to [tblGoraZlecenia].[nazwa] in field tblDolZlecenia.id_gora_zlecenia

Someone know how to write this code? If it is possible ofc