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

Creating related records through a relationship


  • Please log in to reply
24 replies to this topic

#21 BruceR  consultant

BruceR
  • Members
  • 3,320 posts
  • LocationRedmond WA
  • FM Application:13 Advance
  • Platform:Mac OS X Mountain Lion
  • Skill Level:Expert
  • Certification:9, 11, 12
  • Membership:TechNet
  • Time Online: 31d 33m 4s

Posted 22 July 2014 - 06:13 AM

Message 6:

"More to the point, these attendance tables can be generated from any subset of people and/or any subset of meetings."

 

"This script only needs to run once when setting up the database initially, so I really would like it to do all people and all meetings, not a subset of people for one meeting."

 

?


  • 0

#22 Forum Joe  novice

Forum Joe
  • Members
  • 21 posts
  • FM Application:12 Advance
  • Platform:Mac OS X Mavericks
  • Skill Level:Intermediate
  • Time Online: 2h 2m 34s

Posted 22 July 2014 - 03:23 PM

Wow, don’t you think that that was kind of important information for us to know?

 

Yes, I do think it is important, hence I've fixed it now.

I'm sorry that Filemaker/Database is only a tiny part of my working life and keeping my details up to date on a website I use infrequently is not a priority.

 


Message 6:

"More to the point, these attendance tables can be generated from any subset of people and/or any subset of meetings."

 

"This script only needs to run once when setting up the database initially, so I really would like it to do all people and all meetings, not a subset of people for one meeting."

 

?

 

Well, all the records are generated at the beginning, but the attendance tables are just portals that can dynamically show the information based on the current found set.  So when I say the "attendance tables can be generated from any subset" I mean that the user can select which people she wants in the table, and which meetings she wants in the table, and it generates the view of the table based on the data that already exists.


  • 0

#23 comment  consultant

comment
  • Members
  • 24,185 posts
  • Time Online: 328d 23h 41m 6s

Posted 22 July 2014 - 03:28 PM

@Forum Joe: I suggest you edit your post. That remark is totally uncalled for.


  • 0

#24 LaRetta   Lifelong FM Student

LaRetta
  • Members
  • 9,791 posts
  • LocationOregon
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Time Online: 218d 6h 34m 35s

Posted 22 July 2014 - 03:30 PM

Hi Joe,

 

So the idea that a User can select which students and which day to view and complete the Roll Call must be flexible.  But, if I understand, that does not mean it has to be created ahead of time (only DISPLAYED like it looks like it has been created).  And that records only need to track absences and doesn't need to create an empty record for all the days when present.

 

When you view the example I presented, there are no records for the empty slots - only records for the red boxes. :-)

 

If you still need records for every single day then the script Comment suggested should do the trick nicely!!  Otherwise just complete the sample display as I showed, use a global to display the span of time you wish to view and perform a find for the Students your User needs to work on.  


I agree with Comment on your response, btw.


  • 0
Each assumption is an educated guess, a likely condition or event, presumed known and true in the absence of absolute certainty.

#25 Rick Whitelaw  Time Saver

Rick Whitelaw
  • Members
  • 704 posts
  • LocationToronto, Canada
  • FM Application:13 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 22d 8h 56m 16s

Posted 22 July 2014 - 06:37 PM

Forum Joe,

 

  That wasn't a "snarky comment" and Lee is the last person to make himself feel superior via a comment to a post. If Lee chose to use sarcasm in this case I believe it's completely acceptable. This is a technical forum. 


  • 0




FMForum Advertisers