4 Replies Latest reply on Jun 1, 2012 10:56 AM by philmodjunk

    Specified Field Repetition Not Returned with Correct Data

    smoothie

      Summary

      Specified Field Repetition Not Returned with Correct Data

      Product

      FileMaker Pro

      Version

      11.03 Pro Advanced

      Operating system version

      Windows 7 64 bit Professional

      Description of the issue

      This is very strange:

      I have a Settings table with a global field with 7 repetitions.
      On my layout, I have inserted one instance of each repetition (1 to 1, 2 to 2 etc. through to 7 to 7 for a field named Settings::DefaultWorkDays.  In my layout I have made each repetition have a single entry checkbox value list corresponding to the days of the week:

      Settings::DefaultWorkDays[1] has a list named "Sunday" containing "Sunday"
      Settings::DefaultWorkDays[2] has a list named "Monday" containing "Monday" and so on, through to
      Settings::DefaultWorkDays[7] for Saturday.

      When I check and uncheck each of these, I would expect a script referencing Settings::DefaultWorkDays[X] to return the text for the correspnding day of the week if checked and "" if unchecked.

      This is the case for Monday, Wednesday, Thursday, Friday and Saturday, however if I check TUESDAY (repetition 3), I get a value returned of:

      "Wednesday
      Tuesday"

      If I uncheck it I get "Wednesday"

      If I check SUNDAY (repetition 1) I get:

      "Monday
      Tuesday
      Wednesday
      Thursday
      Friday
      Sunday"

      If I uncheck Sunday, I get

      "Monday
      Tuesday
      Wednesday
      Thursday
      Friday"

      It doesn't matter what the checked status of the other days of the week is the same values are returned on Tuesday and Sunday!

      Image of DataViewer showing results with all checked.

      Steps to reproduce the problem

      As above

      Expected result

      As above

      Actual result

      As above

      Workaround

      None found

      RepetionTestScript.gif