Calculating range creating line-entries - fixed.

[balooka]

Hi

Not sure if it should be in ScriptMaker or Fields, but since I'll be needing both I better start here. This one has me going nuts...

I have two weeknumbers+years to calculate their dates (a startdate and an enddate). I have a calc that says how many weeks are between them (counting sundays). What I need is the range between them, like: startweek=40, endweek is 45, the range it should show would be 40,41,42,43,44,45.

To make things worse (for me) is that I want to add a button that will create new records in another table (line), containing the key of the parent record for relational use, but only one number of the range. So in this example I'd get 6 new records, each containing the key, and each populated with one of the rangenumbers.

The use for this is that I need to add orders that'll last a few weeks, but have to be invoiced every week for the work done in that week...

Hope this makes more sense to you than it does to me! :

TIA

JP

Edited October 11, 2006 by Guest