select name from tbl_ter_territories with (nolock) where ownerid = and fsl_tablecode = and territoryid = select #url.territoryid# as territoryId, brokerId, brokerofficeid from tbl_SMA_BrokerOfficeLink with (nolock) where mfr_id = and territoryId = and primaryOffice = 'Y' select BROKER_STREET_ADDRESS, BROKER_STREET_ADDRESS2, BROKER_CITY, BROKER_STATE, BROKER_ZIP, BROKER_AREACODE, BROKER_PHONE_NUMBER, BROKER_FAX_AREACODE, BROKER_FAX_NUMBER from tblBrokerOffices with (nolock) where BROKER_OFFICE_ID = select broker_name, broker_website_url from tblbrokers with (nolock) where broker_id =

#qryTerritory.name#

#qryBroInfo.broker_name#
#qryPrimaryOffice.BROKER_STREET_ADDRESS#
#qryPrimaryOffice.BROKER_STREET_ADDRESS2#
#qryPrimaryOffice.BROKER_CITY#, #qryPrimaryOffice.BROKER_STATE# #qryPrimaryOffice.BROKER_ZIP#
(#qryPrimaryOffice.BROKER_AREACODE#)#qryPrimaryOffice.BROKER_PHONE_NUMBER#
#qryBroInfo.BROKER_WEBSITE_URL#

PURCHASING INSIGHTS

OPERATORS

BROKER STAFF

FILES

NOTES