Action Form – Load Dropdown from SQL

Load dropdown

Select BName,BID from Brands

Load linked dropdown

Select convert(varchar,BID)+’/’+MName+’|’+convert(varchar,MID) from Models
Brands Dropdown

Select BName from Brands

Modesl Dropdown

Select BName+’/’+MName from Models join Brands on Brands.BID=Models.BID
*Note: If you need to escape a character you can use REPLACE

SELECT CAST(T1.ID as nvarchar) + '/' + REPLACE(T2.Name, '/', '\/') + '|' + CAST(T2.ID as nvarchar) as 'Name'
, ,

Leave a Reply

Your email address will not be published. Required fields are marked *