Hi all,

I have 2 tables Contact and Address that are in an updateable view called ContactAddresses (linked using a key field on Address ID).

My problem it that I want to add a new entry to the view but this entry may be using a new address or an existing address. This all worked fine until I tried to add with an Existing Address where upon I get the error 1502 - Visual FoxPro could not write to the selected record because it is in use.

Is there any way to over come this?

Thanks in anticipation.