how to create new records in multiple tables
I have 3 tables(simplified for this example) for a data input form
personID (auto), name
personID, questionID, answer
I am completely stumpted as to how to display all the questions for each new person. If I create a form with the deomgraphics table as the primary choice for the layout, then add a portal for the questions and answer table I can't get any of the questions to show on the form. If I turn it around and create a form with the questions table as the primary choice for the layout, then add a portal for the demograpics table I can see the questions but clicking on new record creates a record for the QUESTION not a person.
Do I need to create a new record in demographics, then expicitly, through a script, create a record for EACH question with autoID value? or does filemaker somehow do this for you?