AnsweredAssumed Answered

How to create a recurring set of records?

Question asked by JohnnyKennedy on May 5, 2011
Latest reply on May 6, 2011 by JohnnyKennedy

Title

How to create a recurring set of records?

Post

Hi

I am building a "simple" advertising booking system with FM Pro 11.

Each record contains the ad details and the week ending (Saturday) date. We record four senarios -

1. Ad occurs once

2. Ad occurs for the next number of weeks

3. Ad occurs every alternate week or month for a number of weeks/months

4. Ad occurs every week until cancelled.

The details captured are publication name (we run eight publications), section, publication date - this is always the week ending date (Saturday), which is then converted to a Week Number.

My scripts search for a publication code and week number to produce a report for each publication and each week etc - all this is working well.

My problem is (and lack of experience) how do I get a record to automatically generate for senarios 2 to 4. Example, I record an Ad for Week 19, and want it to appear for the next four weeks. How do I get FM to generate records for these additional weeks.

Thanks in advance for any suggestions

Outcomes