Re: Over 500 Tasks; Yes/No in project?
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 25 May 2005 12:07:51 -0600
On Wed, 25 May 2005 09:25:25 -0700, "Parts Manager"
<partsmanager@xxxxxxxxxxxxx> wrote:
>Any suggestions or procedure on how to make a table (or use the existing
>Task table and Project table) where I can have a form that an end user can
>pick and choose what tasks are to be in this project?
As with any many (projects) to many (tasks) relationship, the proper
technique is to add a third resolver table: ProjectTasks, with fields
for the ProjectID and the TaskID. Do you REALLY want to default to
having all 500 tasks selected for each and every project? Is there
not some subset of "must do" tasks which apply to every project, and
other tasks that depend on the nature of the project?
John W. Vinson[MVP]
.
- Follow-Ups:
- Re: Over 500 Tasks; Yes/No in project?
- From: Parts Manager
- Re: Over 500 Tasks; Yes/No in project?
- References:
- Over 500 Tasks; Yes/No in project?
- From: Parts Manager
- Over 500 Tasks; Yes/No in project?
- Prev by Date: Storing Foreign Currency Symbols
- Next by Date: Re: linking/embedding images
- Previous by thread: Over 500 Tasks; Yes/No in project?
- Next by thread: Re: Over 500 Tasks; Yes/No in project?
- Index(es):
Relevant Pages
|
