Hi All Good Evening,
I am trying to display check box values when checked in other page.I found that the values are reflecting from databse . So I tried like this.
ELSE IF @fkTerm = (SELECT TOP 1 nID FROM LookUp.Terms WHERE cTerm = 'Additional Property Not Covered') BEGIN SET @cTempTerm = '{Building} Term: {Term}' SELECT @cTermItem = REPLACE( REPLACE( @cTempTerm, '{Building}',cast(c.nLocNum as varchar(3)) + '-' + CAST(c.nBuilding as varchar(3)) ), '{Term}', CASE WHEN nc.cOption = 'Aircraft and aircraft products' THEN 'Aircraft and aircraft products' ELSE nc.cOption END ) + @cNewLine + @cTermItem FROM [Save].PropCoverage c ,[LookUp].[AdditionalPropertyNotCovered] nc WHERE nCoverage = 17 SET @cTermFilled = 'Additional Property Not Covered:' + @cNewLine + @cTermItem END
Here I want to display multiple checkboxes when checked . including that I need to show other details from other table. But these two tables have no matching columns that's why I tried like abouve but not displaying the values.
Please help me.Thanks!