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'