I know this has been done a thousand times before, but not by me.

I need to compare an existing table against a table of imported data (from access) and update the fields in the existing table if a record matches or add an new record if there is no match.

Can anyone point me to a good example using views for such a process in VFP 6.0??????

Thanks!

Lynette