How to create a recurring set of records?
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