This can be done, but the formulas are finicky and you will need different formula based in the repeating cycle (weekly, monthly, quarterly, semi annually, annually). Contact me off line via the information in my profile if you want one on one assistance with this. The other factors is that you need a start date for each reminder, so it knows its anniversary date for the next reminder. I.e. The next reminder is not 1 month after the last one was completed, it will be the next monthly anniversary that is due.
I did an app for this once which I could show you, where all the future reminde rcords were created a future child records to the main Compliance Requirement record. It works well.
