Link to home
Start Free TrialLog in
Avatar of CraigBFG
CraigBFG

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of hhammash
hhammash

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hhammash
hhammash

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
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.
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
Avatar of CraigBFG

ASKER

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
Hi,

What will come from the database,  the questions?

Would you please put the table structure?

hhammash
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
Experts,

A points split was requested by CraigBFG at https://www.experts-exchange.com/questions/20586701/Split-points.html

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

Thank you,

RotaredoM
CS Mod @ EE
Hi RotaredoM,

I have no objection.

hhammash
As requested, points reduced from 50 to 25.

CraigBFG,
Please finalize this question as instructed at  https://www.experts-exchange.com/questions/20586701/Split-points.html


Thank you,

RotaredoM
CS Mod @ EE
Force accepted

** Mindphaser - Community Support Moderator **

webwoman, there is a separate question with points for your help in https://www.experts-exchange.com/questions/20591380/Points-for-webwomen.html