... match the company name of the contact (some of them have several branch ... I need to pull the actual account name. This information is currently ...> ParentContactServiceID=AccId where parenttype is null; This method assumes that every ...a CompanyName entry which matches an Account Full Name. this is how it cross-references contacts with accounts. -- regs Mark ''''No smart-...
...set Parenttype=2, parententryid=AccGUID, ParentContactServiceID=AccId where parenttype is null; This method assumes that every contact has a CompanyName entry which matches an Account Full Name. this is how it cross-references contacts with accounts. -- regs Mark ''''No smart-arsed comments in my signature, so...
... set Parenttype=2, parententryid=AccGUID, ParentContactServiceID=AccId where parenttype is null; This method assumes that every contact has a CompanyName entry which matches an Account Full Name. this is how it cross-references contacts with accounts. -- regs Mark ''''No smart-arsed comments in my signature, so ...
... In the contact view, the contact are linked to the account. In the account view, there are not the contact represented. Can you help with that ... = 2) As for the custom contact field, these are tricky to identify ... cross-references somehow to the Contact via the ContactID, but I have ... to associate the comapny name with account name by using the LIKE comparison...
... like I only have to link up about 2000 of my ... 2) As for the custom contact field, these are tricky to ... cross-references somehow to the Contact via the ContactID, but I ...associate the comapny name with account name by using the LIKE...dbo.NHContacts.CompanyName + '%%' which means match any account which contains the...account name somwhere in the copmany name. - I may give you...
...Type = 2) As for the custom contact field, these are tricky to identify because... this cross-references somehow to the Contact via the ContactID, but I have ... to associate the comapny name with account name by using the LIKE comparison ... + dbo.NHContacts.CompanyName + '%%' which means match any account which contains the account name somwhere in the copmany name. - I may give you some ...
... One of our salesmen loaded accounts and contacts in on 22/8/2008 ...my rudimentary SQL skills to associate the right contacts with the right accounts, but only for the...and check your accounts and contacts. They should be linked up now. ...the views to check the accounts and contacts before you run things and...used a variation to assign primarycontacts to each account, but actually the account...
Great, I appreciate your help. Nancy "farouk drif" wrote: sorry to answer only now but the newsgroup did not notify me of replies, just to say that i'm writing a procedure to explain how to do it step by step, because it seems that it could help a lot of people. i will release it in a few days.
sorry to answer only now but the newsgroup did not notify me of replies, just to say that i'm writing a procedure to explain how to do it step by step, because it seems that it could help a lot of people. i will release it in a few days.
...it takes several hours for the import to complete so I would need...> hello, First, have you already import your data in BCM ? if ... i hope you stored the linking information in a user field ... Which step are you ? The method is to use a temporary ... operate the link between contact and account to link them by ... believe that he did the link. Could you answer my questions ...
