Hi John,

another question: When I now enter new contacts, ie all our staff records, each one will get the company address as the main address. Even so I added the company link I still have to add the address for each record manually.

So if the company would move, I would need to update each staff members address manually.

Is there a reason why the address hasn't been linked when a company is added?

Thanks

Kind regards

Regine

If you want all these contacts to just use the company address, why don't you simply not add an address for the contacts? The idea being that they don't each have their own address but use the company address. The address of the company is still available as an address you can select from when you create an invoice for the contact, of example.

And if you need the company-address-of-a-contact, you can always create a calc field for it in the contact's record.

That seems simpler than trying to loop through all a company's contacts each time you change the company's address--though you could script that too if that's really how you'd like it to behave.

Hope that helps,

John

Thanks John,

In case somebody else is interested I solved it by adding a tick box above the address field "Use Company Address".

I changed the Contacts::AddressBlock field to draw the company address, if the box is ticked and I amended the script "Populate Related Contact Info from Primaries" in the Check Address If clause to:

not IsEmpty ( Contact::AddressBlock ) and IsEmpty ( Contact::AddressUseCompany )

so that it doesn't create an empty address record.

I will use the Contacts::AddressBlock for fmSpark letters, so that's why I wanted it there.

Thanks

Kind regards

Regine

Hi Regine,

Sounds like you arrived at a great solution for this. Thanks so much for sharing this on our forum! Keep us posted with any other questions.

All the best,

Dan
[email protected]