Barry K

  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Barry K

  • Rank
  • Birthday

FIleMaker Profile

  • Profile Updated
  • FM Application
    12 Advanced
  • Platform
    Mac OS Sierra
  • Skill Level
  1. I have a group of students in my class that are all working on different subjects. Each student has unique key id field as so and each student has a subject they are taking which is another field. What I am trying to do is see which subjects each student has not taken yet. So if the key id has records for (history and math) but not reading, I need to have a new field that tells me that I need to have the student take reading next. I bet this could be done via a script but I just do not have the FMP skills to build the script to do this. If possible I would like the script to be able to output as a spreadsheet the key id and the subject missing for each key id. I have attached the filemaker file as well as a screen shot of the problem. Any help would be great, thanks for reading this. students.fp7