Application Dev Question

Out of context: Reply #2

  • Started
  • Last post
  • 8 Responses
  • esko0

    Well, the activity table has a few things that go with it.

    Can be changed if needed,
    and probably will be.

    -Activity ID
    -Description
    -Current Amount Paid
    -Last Month Amount Paid
    -Current Percentage Complete
    -Last Month Percent Complete
    -Date

    And under the admin options they want to be able to go back and look at these numbers at any time, which could be 2-3-4-5-6 years down the road. Basically I wanted to be able to retrieve those numbers in the DB without having to have like 30 fields with just the percent for a given month in each one.

    Don't know how im going to do this but it also needs to be changed dynamically.

    ie - if Feb gets changed to 20 percent from 10 percent and Marches total is 80 percent then March Current Percent has to go to 60 instead of 70. So it needs to have the ability to do something like this.

    I'm open to any method that would work or any possible direction, im still just trying to figure this out.

    esko 0Permalink
    UpvoteDownvote
    Flag
      Show [[ numHiddenNotes ]] more notesAdd Note
      SaveCancel

    View thread