Change Agency

Choose Datasource Development Production

select websiteid, name, portal_name, portal_ownerType, portal_OwnerID from fsenablers..tbl_CUS_Websites where portal_name is not null and portal_type = 'MFR' and portal_ownerType = 'BRO' order by name Choose Broker #htmleditformat( name )# select bidId, bidName, bidNumber from tbl_BID_Bids where ownerId = and ownerType = 'BRO' and deleted <> 'Y' order by bidNumber Choose Bid #bidNumber# - #htmleditformat( bidName )# select distinct a.bidAgencyId, a.bidAgencyName from tbl_BID_Bids b inner join tbl_BID_Agencies a on b.bidAgencyId = a.bidAgencyId where b.ownerId = and b.ownerType = 'BRO' and b.deleted <> 'Y' order by a.bidAgencyName select bidAgencyId from tbl_BID_Bids where bidId =

Details
Agency:	#htmleditformat( bidAgencyName )#

update tbl_BID_Bids set bidAgencyId = where ownerId = and ownerType = 'BRO' and bidId =