AnsweredAssumed Answered

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

Question asked by Gert on Oct 12, 2009
Latest reply on Oct 26, 2009 by 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?

















Outcomes