5 Replies Latest reply on Oct 26, 2009 9:24 AM by Gert

    Relation not updated after one of its selecting fields gets a new value

    Gert

      Title

      Relation not updated after one of its selecting fields gets a new value

      Post

      ---------------------------------------------------------------------------------------------------------
      #File System

       System::WorkingYear    

      ---------------------------------------------------------------------------------------------------------
      #File Teachers:
        Teachers::cWorkingYearCopy   = System::WorkingYear (numeric)


      ---------------------------------------------------------------------------------------------------------
      #File Contracts:
       
      TO Teachers
      TO Appointments

      A relation Teachers  --> Appointments

        Teachers::cWorkingYearCopy   --> Contracts:Appointments::Year (numeric)
        Teachers::ContractId             --> Contracts:Appointments::ContractId (numeric)
        Teachers::gAppointmentType  --> Contracts:Appointments::Type (Text)
      ---------------------------------------------------------------------------------------------------------

      A portal in the file 'Contracts' on a layout for Teachers shows records for this relation.

       When the System::WorkingYear field is changed on another layout,
       the copy in the Teachers file is updated accordingly, but the relation to Appointments is not updated to use this new value.
       Even when the  the window+portal is refreshed after visiting other Teacher- records.
       
       The relation selects records for the ContractId of each Teacher, but not for the new WorkingYear.

      After closing and re-opening the files however, the correct value for WorkingYear is used.

      (FM8, FM10 on windows )

       Did I miss a rule in the Documentation? Is this behaviour as expected?