Multipage DB form query with radio buttons

Using FP 2002 to develop a database driven questionnaire.
I can get the whole thing to work by using drop down boxes and passing hidden variables to the next form and so on, but I want the first few pages to be radio button driven.

For example :

Page1 - Is your defect...a) internal b)...external

pick internal, then shows questions based on internal

Page 2 - Is your defect... a) electrical  b)water  c)gas

thanks
CraigBFGAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hhammashCommented:
Hi,

<HTML>
<HEAD>

<SCRIPT LANGUAGE="JavaScript">

function DispText (val) {
frm=document.forms[0]

     if(val=="option 1")
document.MyForm.Dispq.value="This is the Internal question";

     else {
     document.MyForm.Dispq.value="This is the external question";
     }

}

</SCRIPT>

</HEAD>
<BODY TEXT="000000" BGCOLOR="FFFFFF">

<FORM name="MyForm">

<INPUT TYPE=radio NAME="f1" VALUE="option 1" onClick="DispText
(this.value)">Internal
<INPUT TYPE=radio NAME="f1" VALUE="option 2" onClick="DispText
(this.value)">External<p><input type="text" name="Dispq" size="85"></p>
<P>
&nbsp;

</FORM>
</BODY>
</HTML>

hhammash
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hhammashCommented:
Hi,

In FrontPage, double click the textbox, click style, borders then put the textbox border to be with the same color of your background.

This is a textbox with white borders which make the textbox invisible,  so when you click the the option it will display the question as if there is no textbox.

<input type="text" name="Dispq" size="85" style="border: 1px solid #FFFFFF"></p>


hhammash
0
webwomanCommented:
There's no difference between radio buttons and other fields. They pass values the same way. It's just the way they look that's different.

If you were using dropdowns, there's no reason you can't use radio buttons instead. Just use the same name as you did for the dropdowns for the group of radio buttons, and give each of them a value, the same as you did for the dropdowns.

The user will only be able to select ONE button in the group. Selecting a different button in the group will toggle the other one off. However, when they click the submit button, there's no difference between the radio button and any other form field that has a value.
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

hhammashCommented:
Hi CraigBFG,

I forgot to tell you that Option 1 in my code above is the value of the Radio button,  so you have to change it with your value.

You have a group name for the Radio Button and you have the value.  Put the value that you like then use it in the code.

hhammash
0
CraigBFGAuthor Commented:
That's ok, but the values have to come from a databasenot be hard coded into the page.

I've tried using radio button instead of a drop down box but it doesn't seem to work.

Any more ideas?
Craig
0
hhammashCommented:
Hi,

What will come from the database,  the questions?

Would you please put the table structure?

hhammash
0
hhammashCommented:
Hi,

I will work according to your table structure.  You can send the table to me to hmaf@yahoo.com with test records in it.

hhammash
0
RotaredoMCommented:
Experts,

A points split was requested by CraigBFG at http://www.experts-exchange.com/Community_Support/Q_20586701.html

If no objections are made within 72 Hrs, I'l split as requested.

Thank you,

RotaredoM
CS Mod @ EE
0
hhammashCommented:
Hi RotaredoM,

I have no objection.

hhammash
0
RotaredoMCommented:
As requested, points reduced from 50 to 25.

CraigBFG,
Please finalize this question as instructed at  http://www.experts-exchange.com/Community_Support/Q_20586701.html


Thank you,

RotaredoM
CS Mod @ EE
0
MindphaserCommented:
Force accepted

** Mindphaser - Community Support Moderator **

webwoman, there is a separate question with points for your help in http://www.experts-exchange.com/Web/WebDevSoftware/FrontPage/Q_20591380.html
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.