>I am working on a small application where I want the user to be able to setup their budget based off fiscal year (oct - nov). How do I have thesystem to automatically allow them to enter the data in and ensure that the months are properly populated without having to go through add physicall add the months? (is this confusing? )
Some shops enter and report by date ranges. For example, the first quarter would be allocations to months 10,11, and 12. At report time, for quarter one, the user would ask for allocations applied months 10 through 12.
However, if you want want to translate the months to quarters, you could set up a translation file:
Month Quarter Description
10 01 Quarter 1
11 01 Quarter 1
12 01 Quarter 1
01 02 Quarter 2
02 02 Quarter 2
.....
09 04 Quarter 4
This way, date based allocations could be allocated to fiscal quaters at report time.
Imagination is more important than knowledge