>How can I add a record to an MDB table in VFP9 - I want to create just 1 record with a value in 1 field
>
>Thanks
>
>Colin

Hi Colin

create a remote view and select your update criteria. Keyfield etc then tick send sql updates . The you can insert and update records via the remote view.

Nick