Results 1 to 2 of 2
2006-09-15, 18:54 #1
- 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.
2006-09-16, 00:40 #2
- 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".Charlotte