There is one Column
Parent _id
in
Question
Table. I guess you can use that.
For the two questions "
Do you currently use..." and "
Are you exposed to...", you can update the Column
Parent_id
to 5, which is the
Answer_Id
for
"Current Smoker" in Answer Table.
This way, you can relate. So, when
"Current Smoker" is selected, you query to
Question
Table like...
SELECT Question_Id, Question FROM Questions WHERE Parent_id = 5
5 (
Answer_Id
) is passed from code behind while querying.
Makes sense?