Hallo experts.
I have insert with a insertform values in a table artikel and column test_column.
I have got the values from a checkbox group.
The test_column now has values like 20,30,60,70,80,90.
I have also a table Detail with a column detail_ID and Detail_text.
The detail Id has all the available numbers 20,30,40,60,70,80,90,100 and the detail_text word of each number.
How can i get now the Detail text in my Detail page with a query instead the values from the test_column?
(table artikel
test_column
20,30,40
and
table detail
detail_Id detail_text
20 test1
30 test2
40 test3
50 test4
I want in the Detail Page the words test1,test3,test4)
Any help?
(I use CF8 and MS SQL)
Start Free Trial