Cant add record

[Banana]

1) That was what I did at first. I left-joined Client and Address to Entity in single query but I had same problem of partial updating.

Is there other suggestions before I try #2?

 

[Banana]

Yay!

Subform does work- and better yet, I got it to be transparent so users'll never know there was a subform.

You're a treat, Pat!

 

[Banana]

I have to be able to store both mailing and physcial address in case if they are not the same. Rare case, but that is my requirement from uppers. Also, since they will also relate to business, who may have multiple office, this give me more scalablity.