New record at the start of each month

[merkaba22]

I have created a portal based on a date_calc for month and year; for example, July 2005 reads as 72005 in "sales records" and a "montly sales listings" each with their respective tables.

And it works fine: if I enter in say, 72005, in the date_calc field in "montly sales listings" all the sales records for July 2005 show; for 62005, all records for June and so on:)

What I would like to accomplish is a bit out of my expertise such as it is.

Is there a way for FM7 to notice the passage of time such that when the creation of records for sales move from 72005 to 82005, a script will trigger the creation of a new record in monthly sales?

And then again as the date_calc moves from 82005 to 92005 and so on?

[comment]

No, not really. But it shouldn't be necessary either. I mean what information does a database of months hold? That there was a month of July, 2005? Everyone already knows that.

When you need to view a monthly summary of your real records, generate the month/s on-the-fly into global field/s.

[merkaba22]

I figured it out:)

Thanks for being there ....