AnsweredAssumed Answered

Calculate and Display Dates from Portal in Parent

Question asked by pademo57 on Apr 7, 2017
Latest reply on Apr 7, 2017 by pademo57

I have a relationship between Course table and Course_Details table:

CRS::_pk_CRS_ID -> CRSDET::_fk_CRSdet_ID

 

In the Course Layout you can add a new Course which has a Course Name, Overall Start Date and Overall End Date.

In the portal from Course_Details you can add Sections.

 

Each Section requires a CRSDET_Name, CRSDET_Start Date, CRSDET_Number of Days, CRSDET_End Date

 

What I would like to do is when someone changed the first Section Start Date it will automatically put it into the Course::Overall Start Date

 

Also when someone has finished adding sections that it puts in the last portal record CRS::End_Date into the Course::Overall End Date.

 

I tried using a script trigger that when someone modifies a Start Date or and End Date it updates the Overall field but it doesn't work.

 

Can someone shed some light on this please.

 

Here is a snapshot:

Course Days.PNG

I put the dates in to show where I would like them to show up

Outcomes