Thanks - is it possible to point me in the right direction so that I can investigate and implement.

much appreciated.

Hi Ian,

In the past, when a client has asked this, we have created a new search to handle this, which is focused on the address, and joins to the company.

First thing we did was write a view, which would return all the addresses, when a company name was searched, or the address, if a post code was searched etc.

Something like: -

SELECT DISTINCT(addr_addressId),addr_address1,addr_postcode,comp_name
FROM Address
INNER JOIN Address_link on AdLi_AddressId = addr_addressId AND adli_deleted IS NULL
INNER JOIN Company on AdLi_CompanyID = Comp_CompanyId AND comp_deleted IS NULL
WHERE addr_deleted IS NULL

Then, we created the screen and associated list, and added this as a find option, on the find menu.