I have created a database consisting of 2 tables.
one table called names which holds the flac_Ref , cso_ref and name.My child table , Data, holds flac_ref , fee , vat ,
code , total and date.

I have now been asked to transfer the corresponding cso_ref into the data table.I have been trying to use an array to hold the flac_ref and cso_ref from the name table and then search through the data table inputing the corresponding.

So far , I have been unable to do so. Could anyone give me a
few pointers in the right direction ?

Thanks

Darren