I'm having problem with the following repeating field that is supposed to get a text field (MSN_full_related::msn_mission_number) from a cartesian related record based on a calendar start date:
eval_date > Extend (MSN_full_related::msn_dep_day)
eval_date < Extend(MSN_full_related::msn_return_day) + 2;
Precisely, the calculation will only return the value on the first record that was created, which is usually not the first repetition. If the date range of the first created record goes for several repetitions, it will fill in each repetition. It just won't evaluate records other than the first created one. None of the date ranges overlap.
Any help would be appreciated.