Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    138

    Unanswered: Progress Summaries

    I have a youth database which holds all of the youth information for a facility.

    I need to add a table that will track monthly progress summaries for each youth. Every youth (as long as he or she is a resident in the facility) will receive a monthly progress summary.

    In Jan, Feb, Mar, etc. I need the field to show Yes, they've had a summary, or N/A (not applicable for that month [based on entry date]) or be null to show that the summary is due.

    Each field needs to start over for the following year.

    Any suggestions? Thanks!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so have a sub/child table which uses the memberID and a date as the PK
    by the looks of it a memberid + year + month could be a good candidate key.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •