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.
Caroline