SELECT Broker_Name BrokerName, Broker_Id FROM dbo.tblBrokers WHERE Broker_Id IN (SELECT OwnerId FROM tbl_IMPORT_Aliases WHERE OwnerType = 'BRO' GROUP BY OwnerId ) ORDER BY Broker_Name SELECT BrokerName, Broker_Id FROM qmd_BrokerList WHERE Broker_Id = #_BrokerId#

#_postpage# - #application.dsn#

Select Broker:  

     
Invalid Broker Id SELECT T.Name as TerritoryName, T.TerritoryID, * FROM tbl_TER_Territories T WHERE T.ownerId = and T.fsl_tablecode = 'BRO' Select Territory:  

Preview   Commit

         Invalid Territory Id

Broker Id: #FORM.BId#
You Selected Territory: #FORM.SelectedTerritoryId#