>>what's the relation between name and data? 1-1 or 1-many
u answer the "why" q.
what about the "what" q. ?
if it is a 1-1 relation u can do it with a single SELECT
something like

Select data.*,name.cso_ref from data,name ;
where name.flac_ref=data.flac_ref ;
into table new_data

if the relation if 1-many u may have to resort to using
a scan loop on the data table

Arnon