comp_primaryaddressid should be set to the addr_addressid of the address you want to show up on the company summary screen. At least one record also needs to be create in the address_link table with adli_addressid being the address record id, dli_type being the address type (such as 'Business'), and adli_companyid being the company id the address is for.

For background information please see

community.sagecrm.com/.../all-about-addresses-a-round-up-of-articles-that-discuss-addresses-and-their-management-in-sage-crm.aspx

There wasn't one, so I wrote one!

Daniel...Thanks I will take a look at this. I think this is what I did when I imported the data...but nothing showed up on the addresses tab. I will double check what I have with your information. Again thank you!

Jeff...Thanks! I thought I remembered seeing a round up on Phone and Email ... but I did not realize there was one on addresses. I will read through this and see if I can get my addresses to show up on the addresses tab. If not, I will post back. Your assistance is always greatly appreciated!

Awesome! Thanks Jeff...

I have looked through some of this today ... but I am just not seeing yet why I don't have any data on the Address Tab of the company record. I have data in the company record, the address record and the address_link record. I am going to look at it some more tomorrow. I am sure that I am just missing something silly.

Thanks!

My advice is to run a SQL trace. When I do this, I see the SQL that is run is (7.3 SP1):

select *

from vListAddress WITH (NOLOCK)

WHERE AdLi_PersonId IS NULL AND AdLi_AccountId IS NULL AND AdLi_CompanyId=4233

ORDER BY Addr_Street, Addr_AddressId

So, you need to ensure that your address link records do not have a person ID or an account ID against them for them to show up.

All the link tables in CRM are horrible to work with, and I would suggest getting a vanilla system, putting some data in it, and then looking how it builds the links.

Thanks Toby!

I will run your query and see what I get...but I think you might have hit the nail on the head with..."ensure that your address link records do not have a person ID or account ID against them".

I think I might have put the personid and the companyid on the same line in the address link record. Therefore, I bet if I go in and add another record in the address link table with just the company id, it will show up. I saw that in some data I was looking at but I was wondering why that would be necessary (have a record with the personID and the CompanyID and then another record that had only the CompanyID).. As long as I know it is necessary, I can accommodate it. I will let you know if that was the trick. Thanks!