AutoFill Child Table with Report Milestones

[vanderLeest]

What I hope to do, is autofill a table based on submitted start and end date of a project.  The  routine to be developed should create a record in the Milestone table for each 6 months period the projects lasts.

i, mx, dur as integer

dur = Round((DateDiff("m",[SA_StartDt],[SA_EndDt])+1)/6+0.3,0)  = number of records to be created

For i = 0 to dur

mx = i * 6

Proj_ID         //   Period_No //  Period_StartDate       //       Period_EndDate         //         Budget

[Proj_Recno] // i + 1 //  DateAdd(month, mx, [SA_StartDt])  //  DateAdd(month, mx+6, [SA_StartDt])  //  [SA-Awarded]/dur)

 

Can I set this up as a trigger action on the table? or do I need to write a bit of Javascript and add this to a button?

In both cases, I would appreciate some pointers.

 

Floris

 

[MayMusic]

Since there is no loop function in built in trigger you need to have Caspio write a trigger in database for you to perform this task