Hi Mark,

I went through what you sent and it is great but I have a couple of
questions that I am hoping you can help with:

1 - My account names do not always match the company name of the contact
(some of them have several branch offices with different names) so I need to
pull the actual account name. This information is currently stored in a
custom BCM contact field, is there any way to update the parent account info
from a custom field? I looked through almost all of the SQL tables but I
can't find these custom fields or the data entered there.
2 - In NHUpdate, it is pulling NHAccounts.AccGUID and NHAccounts.AccID. I
get an error for AccID. I know this is because it doesn't exist as a field
in NHAccounts but I couldn't figure out which field it should be. Am I
missing something besides my sanity?

I'm sorry for all of the questions, You may only have "rudimentary" sql
knowledge but it's far stronger than mine!

Again, I appreciate you taking the time to help out with this.

Nancy

"Mark W" wrote: