Jump to content
  • 0

AutoFill Child Table with Report Milestones


vanderLeest

Question

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

 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...