Creating a relationship between data fields

[lmichco]

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.

 

[Duane Hookom]

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.