is it possible to have different values (per record) in same SELECT field?

Applications Forms
#1

I have 2 tables in the database:
master table QUESTIONS containing questions
child table ANSWERS containing question id and valid answers (foreign key to QUESTIONS table).

I want a form (editable grid) to display all questions and corresponding valid answers. It’s like a simple survey application.
Can I make this so that each question record only shows valid answers to that specific question?

ID Question Answers (SELECT)
1 C# skills good
average
poor

2 Age 0-20
21-40
40-80

etcetera…

is this possible in SC?

Any help is very much appreciated!

#2

Re: is it possible to have different values (per record) in same SELECT field?

if function on sql query

regards
masbro

#3

Re: is it possible to have different values (per record) in same SELECT field?

Hi.
What DBMS do you use in your project ?

#4

Re: is it possible to have different values (per record) in same SELECT field?

MySQL v5.

Using the IF/CASE function in the query is actually a good suggestion, thanks!