Newbies jvdweg Posted October 4, 2007 Newbies Posted October 4, 2007 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.
Inky Phil Posted October 4, 2007 Posted October 4, 2007 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
Recommended Posts
This topic is 6354 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