Jump to content

  •  

Photo

A simple Survey that I can't seem to get my head around


  • Please log in to reply
4 replies to this topic

#1 markreynard  newbie

markreynard
  • Newbies
  • PipPip
  • 2 posts
  • FM Application:13
  • Platform:Cross Platform
  • Skill Level:Novice

Posted 27 January 2014 - 05:09 AM

I am wanting to do a simple questions survey.

 

I have a participant table, a questions table, and a Results table.

 

I would like to show all the questions entered  from the questions table in a portal linked from the participant.

 

I would like to record the result of the question in the Results Table.

 

I understand that you can create a copy of all the questions in the results table for each participant, but I don't want to fill the results table up with unnecessary records.

 

The attached file is a simple version of what i am trying to do.

 

Please help

 

Attached Files


  • 0

#2 Fitch  Imaginary friend

Fitch
  • Moderators
  • 4,048 posts
  • LocationPortland, Oregon
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:7, 8, 9, 10, 12, 13
  • Membership:TechNet
  • Time Online: 16d 17h 9m 28s

Posted 27 January 2014 - 09:38 AM

Which records are unnecessary?


  • 0
Tom Fitch :: Portland, Oregon :: Fitch & Fitch: FileMaker consulting

#3 eos  Paris 2016 … :-)

eos
  • Members
  • 1,139 posts
  • LocationTegernsee, Bavaria
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 216d 20h 18m 13s

Posted 27 January 2014 - 10:10 AM

See if this thread is of interest to you:

 

http://fmforums.com/...-relationships/


  • 0

#4 markreynard  newbie

markreynard
  • Newbies
  • PipPip
  • 2 posts
  • FM Application:13
  • Platform:Cross Platform
  • Skill Level:Novice

Posted 27 January 2014 - 02:08 PM

Spot on that, thank you very much.


  • 0

#5 Rick Whitelaw  Time Saver

Rick Whitelaw
  • Members
  • 759 posts
  • LocationToronto, Canada
  • FM Application:13 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Time Online: 24d 7h 46m 37s

Posted 27 January 2014 - 02:28 PM

When I enter an answer in your startup layout all four questions then have the same answer. This is likely because of the Cartesian relationship.
  • 0




FMForum Advertisers