Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


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,026 posts
  • LocationPortland, Oregon
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:7, 8, 9, 10, 12
  • Membership:TechNet
  • Time Online: 16d 10h 6m 45s

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,032 posts
  • LocationTegernsee, Bavaria
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 204d 14h 59m 14s

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
  • 706 posts
  • LocationToronto, Canada
  • FM Application:13 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 22d 11h 52m 47s

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