What kind of database? What is this called?

[noboost4you]

Problem:
Ask one question, depending on the answer, ask the next appropriate question and so forth down the line (see the image attachment) until they reach the end of the questions and out spits the proper part number.

I want to say this is a relational database, but I can be completely off target. Essentially, like the image portrays, I want to ask the first question -- "What are you measuring?" Depending on their answer (Pressure, Level, Flow, etc.), I need another box/question to pop up asking the next appropriate question.

What am I looking for? What is this called?

Regards,
Bryan

[cs3mw]

Do thse questions need to be edited by a possible client? If not I would suggest doing this type of functionality with a server side script.

Kind Regards

[noboost4you]

Do thse questions need to be edited by a possible client? If not I would suggest doing this type of functionality with a server side script.

Kind Regards

Questions cannot be edited.

We will ask the questions in proper order. Based on the user's choice/decision, a new menu will appear with the next question and available choices. Then once there are no more questions, we output the part number based on the user's answers.

So essentially, each answer/choice to each question will be assigned a number or letter designator.

[NogDog]

You might try searching the web on "expert systems" for ideas on this.

[ssystems]

If I understand it correctly that questions and options are fixed values you can try this structure.


quetion
questionId
questionText
parentOptionId

Options
optionsId
questionId
OptionValue
OptionText

Parts
PartId
PartName
....
PartValue


You might want to utilize bitwise operation here if you'd like.

[noboost4you]

If I understand it correctly that questions and options are fixed values you can try this structure.


quetion
questionId
questionText
parentOptionId

Options
optionsId
questionId
OptionValue
OptionText

Parts
PartId
PartName
....
PartValue


You might want to utilize bitwise operation here if you'd like.

They are fixed values, but depending on what you choose, the appropriate next question must be asked with the corresponding choices.

I'm reading up on Expert Systems as NogDog recommended and from what I've read so far, it sounds identical to what I'd like to achieve. Getting there on the other hand...