Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Littleton, Colorado, USA
    Thanked 0 Times in 0 Posts

    Link to Activity in Same Table (A2K, SP3)

    I'm sure this has been covered before, but I'm not even sure how to search for it.

    I'm putting together a database to track activities. These activities will have a start date and a duration, as well as various other information. In many instances, there will be activities dependent on other activities already in the table. I'd like to be able to create a report that flags what activities are dependent on others, and possibly even move their start dates when the parent activity end date moves. I can envision doing this using two separate tables, but this approach seems wasteful. <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    Thanks in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Link to Activity in Same Table (A2K, SP3)

    That approach may seem wasteful, but it is proper relational design. Anything else becomes a maintenance nightmare.

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> Try doing a Lounge search on the phrase "many to many".

Posting Permissions

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