Newbies chow Posted April 11, 2011 Newbies Posted April 11, 2011 Hello all, I am a beginner to Filemaker Pro and hoping for some advice. Also, apologies if this has been addressed already. I'm creating a survey database for school based health centers; this survey is meant to either be filled out by students on a computer, OR enable a research analyst to quickly enter the data from paper based forms. After reading several threads on this forum about survey design, I think I have a decent model (please see attached). As depicted in the diagram below, I have split the relationship graph into two components. The top half in yellow represents survey responses with unique combinations of questions and responses. The bottom blue-green half contains the model for the survey---it's conceivable that the stakeholders will want different surveys in this database. The main difficulty I run into is the variety of response types. For this survey there are three types of responses: most are multiple choice; some are free text entry (e.g. how old are you?), and one is a checkbox response (e.g. check all the issues that apply). As it stands I have a layout based on the table "Filled out Surveys", with a portal that points to Questions 2. This allows me to display all the questions in order. However, it doesn't permit me to change the field according to the question type. Am I missing something or do I need to change my approach? Any help is greatly appreciated! Best, Chow
Recommended Posts
This topic is 4974 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now