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!