Database function

[skynight]

Hope this is the correct place to post...

In Excel I can set up a database that allows me to ask questions, getting a YES or NO answer for each, and calculating the responses (number of YES compared to NO, expressed as a percentage etc). I wanted to set up a template for such a function to use for a series of questions in FP7, allowing the user to answer each by checkboxes or radio buttons, and to add comments to each page before going on to the next question (next page, same template). I tried putting the basic data into the Header part and only the questions in the Body, but when I try to change the question in the next page, it changes the question in all of them. I know it can be done, but dang it, I cant make it perform. can someone please help me and save my job?

[CobaltSky]

Hi skynight,

It's not entirely clear what you mean here, but it would be normal to have the answer field appear in the same part (eg the body) as the question. That way there can be no dounbt as to which question the answer relates to.

However, if you are not already doing so, you might also wish to consider having the actual answer fields located in a separate table from the questions (and sourced via a relationship which matches on both personID and questionNo). That will not only be an efficient storage method, but will accumulate all the result data in one place where it will be easy to access andf summarize.

[skynight]

Would this separate table be in FP7 or perhaps in an associated data base program (such as Excel)?

[CobaltSky]

Would this separate table be in FP7 or perhaps in an associated data base program (such as Excel)?

In FileMaker (probably within the same file) so that you will be able to use FileMaker's internal relationship structures to manage (and summarise) the data to best effect.