understanding of what you do on assignments. Start from the University Starter table (located in Assignments > Assignment 11 > Files For Assignments on Learn ). Do not use your previous assignment files for this assignment. A.Create a layout called “Choose” (shown to the right) in the Markstable and on it place a button and global text fields named WhichCourseand WhichOrderThe user should select a value forWhichCoursefrom a popup filled by values of the Course field. WhichOrdershould be filled from a two-element custom value list containing “By Name” and “By IDN”. By the time you’ve finished step H, the DoItbutton will execute a FileMaker script that displays a list of the students taking the specified course, sorted by the indicated field and showing each student’s mark for the course.(See Figures 3 and 4.) B.The reports you create subsequently will assume that you have done a Find to isolate the mark records for the course named by the global field WhichCourse. We will therefore need a script that does this. Write one, and give it the name “Do Find”. Here’s what the script needs to do: •With the Chooselayout displayed, copy the contents of the global field WhichCoursethe Mac’s clipboard. •Switch to a Marks layout containing the Coursefield. •Enter Findmode, paste the clipboard’s contents into the Coursefield, and perform a Find. (The resulting “found set” contains only mark records for the selected course.) •Arrange that this macro appear on the Script menu, so that it can be executed either by a menu selection or by pressing the command key FileMaker assigns to it (as shown on the Scriptmenu). C.Reports are viewed in Previewmode. Unfortunately, buttons don’t work in Previewmode. So to make it easy to return to the Chooselayout from the display of a report, write a macro named GoToChoosethat puts FileMakerin Browsemode and switches to the Chooselayout. •Make GoToChoosethe topmost item in the Scriptmenu so that it can be executed by pressing ⌘-1 (since that’s easy to remember). •Make the script Do Findthe 2nd item in the scripts menu so that it can be triggered by pressing ⌘-2. . to
CS200 Assignment 11 Page 4 of 9 You will find these scripts useful while working on the reports. D. Create two reports in the Marks table that list the marks for each student in a particular course, together with that student’s grade for the course. One report (“ By Name [Detailed] ”) should list the students by name; the other should list the students by ID number (“ By IDN [Detailed ]”). ( See Figures 1 and 2.) • The body parts of these reports show a Marks record’s course, registration number, and assignment number to help you verify that you are reporting the correct data, although the first two would more appropriately be placed in a sub-summary field since they are (or at least should be) the same for all the records in a group.
You've reached the end of your free preview.
Want to read all 9 pages?
- Spring '14
- Regular expression, The Script, FileMaker