AnsweredAssumed Answered

how to create new records in multiple tables

Question asked by mnigogos on Aug 21, 2011
Latest reply on Aug 23, 2011 by philmodjunk

Title

how to create new records in multiple tables

Post

I have 3 tables(simplified for this example) for a data input form

Demographics table:

personID (auto), name

Questions table:

questionID, question

Answer table:

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?

Outcomes