>What I have to do is scan through a dbf called QPDATA. The fields are:
>
>QPDATA.FIELD
>QPDATA.DATA
>
>Then goto a table called:
>
>LXPOS.DBF;
>
>The fields are
>
>LXPOS.DATA
>LXPOS.INPUT
>
>Next replace the field;
>LXPOS.DATA with QPDATA.DATA where QPDATA.FIELD = LXPOS.INPUT. The are about 300 records.
>
>I have a Brain Ache...
Try this, but backup your data, firstly
UPDATE lxpos SET data=(Select data from qpdata WHERE field=input)
Edward Pikman
Independent Consultant