Hi Caroline,

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

This is the problem with having two updatables tables in a view. When you add a new record to the view, you are adding a new record to both updatable tables (in effect). You don't really want a new record in the address table, you just want to use the key for an existing address record in your new contact record. You really need to separate the updatable view into two. I always follow a rule of only one updatable table per view.

pamela