AnsweredAssumed Answered

Multiple dates in a field

Question asked by firth5 on Feb 22, 2010
Latest reply on Feb 22, 2010 by firth5

Title

Multiple dates in a field

Post

I've designed a Design database, where each record is one design.  Each record has a series of approval date fields, which show a timeline going through the various approval stages.

 

For example, for each design we have the following dates:

 

Assigned

Submitted

Reviewed 

Approved

 

 

Right now, I have one field for each approval stage, above.

I would like to be able to enter multiple dates in the "Reviewed" field, which would therefore track the number of revisions that design had to go through.

 

What's the best way to do this?  Child table?  If so, please give me a jumping off point.  I have yet to use related tables in any significant way.

 

I'd like to have a calculation field that is tabulating the number of revisions a design has gone through at all times.  

 

Thanks in advance,

eric 

Outcomes