Looks like a good start, but I think you'll want a link from tblQuestionAnswer to either tblChild, tblParent or both.
(You may want to put parents and children in the same table.)
That's right I forgot to add that link. I think i need the children and parents still separate because it will be a many to many from the subjects we're looking at and there will be other tables linked to both.
I actually just thought of another question related to this. Once the survey has been created in the tables, I'm wondering how the layout will work. Meaning, how will data entry happen on a question by question basis. I'm still pretty new to filemaker so I may not know all the ins and outs just yet.
Thank you for your reply!
You can use two occurrences of the same table, one for parents and one for tables. This may or may not be a good idea. But it simplifies linking a person to their answers--which is why I am suggesting that you consider that approach.
If "table occurrence" is a new term, see this link: Tutorial: What are Table Occurrences?
There are quite a few different ways that you can set up a layout for a person taking the survey.
Will this survey be taken sitting at a computer running fileMaker or might it be done over the web?
What kind of answers will you be collecting? Text answers? Multiple choice answers. Answers formatted to use the same scale?
The survey will be taken by someone sitting at a computer with filemaker pro installed. The kind of answers range from dates or times, multiple choice, and answers from different scales. For example there are different scales for demographics that ask age and gender and other sections have questions where the responses can be "never, sometimes, often, always."