October 4, 200718 yr Newbies Hey, my first question as a FMP user. Previous attempts using Access worked, so I wonder why I have problems now. I want to have 1 layout with on the top some general person's data, below that should be several tabs each containing answers to a specific questionnaire. 1 person could have filled in a specific questionnaire more than 1 time, and I need some controls on that tab-form to switch between these records... So: a table for each person and a table for each questionnaire, right? 1 to many, right? but already this gives me a hard time! -) > Thanks in advance.
October 4, 200718 yr Relate the person table to each questionnaire table via a unique person id. Put a portal in each tab. Set each portal up to show records from the questionnaire table relevant to that tab. HTH Phil
Create an account or sign in to comment