Randy - not sure what you're asking here ?
topic says form - body says database and table .

you want to update fields ? change the structure ?
or do you want to update the content of a table , changing values stored in the fields ??

Do you have PK's in use anywhere between the tables ??

mondo regards [Bill]

>Hi. VFP7 user. What is an efficient way of updating fields in a larger database from a smaller one? Note: OK to create a sql cursor with the contents of the large table as updated by the smaller.
>
>Thanks, Randy