Next Due Date for an annual agrement

Question

This has got to be a DB design question.&nbsp;&nbsp;

The App is called IT Software Maintenance Agreements.&nbsp; Table is Annual Agreements.&nbsp; Fields are things like, Software, Vendor, Budget year, Budget Type (Estimate, Actual), Account Code, etc.&nbsp; Next Due Date is one of the fields.&nbsp; Problem I am running into is, let's say I paid for a five year deal upfront.&nbsp; I would have a zero dollar entry for year 2.&nbsp; Same for year 3.&nbsp; I guess I can make that entry each year and then just reflect the Year 5 renewal date each time.&nbsp; Just thinking there is a better way to handle this.&nbsp;&nbsp;------------------------------Gonzo -  A Newbie, but learning fast.  (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------

tonygonzalez · Answer

Gonna Answer my own question.&nbsp; I can build, and not miss line items, my budget based on renewal date with a simple report.&nbsp; I don't have to make "dumby" entries just to keep a agreement in the current budget year even with no renewal date.&nbsp; Using a formula/filter should be easy enough.------------------------------Gonzo -  A Newbie, but learning fast.  (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------

Forum Discussion

Next Due Date for an annual agrement