If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a relationship between data fields
I have designed a database that tracks various stages of a process. Within
each stage there are multiple dates and comments that are tracked. For some reports I need to show all of the dates and comments for all of the stages, for other reports I only need to show the dates and comments associated with the most current stage. How do I design the database to allow this to occur? Right now I have all of my information coming from one table. |
#2
|
|||
|
|||
Creating a relationship between data fields
I assume you have a "process" table. I would also have a stages table and
possibly substages. You could then use a process vs stage table that would store one record per process per stage. Every stage of every process would create a new record in this table. -- Duane Hookom Microsoft Access MVP "lmichco" wrote: I have designed a database that tracks various stages of a process. Within each stage there are multiple dates and comments that are tracked. For some reports I need to show all of the dates and comments for all of the stages, for other reports I only need to show the dates and comments associated with the most current stage. How do I design the database to allow this to occur? Right now I have all of my information coming from one table. |
Thread Tools | |
Display Modes | |
|
|