Creating a Log

I am in the process of designing a table and I am not sure what the best way
to approach the design is. In summary, I have one table, lets call it
t_Manuals. This contains the following field ManName, ManDate, and
Man_Revision. This table is full of manuals and for right now they all have
the value of 0 in the Man_Revision field, becasue they are the originals.
However, I want to be able to track changes to these. I was thinking that
I would create a table called t_ManRevisions, which would have the same
fields. Each new record would be a record of a revision. I am not sure how
well this will serve my purpose...at the end of the day I would like to run a
query that will show all of the Manuals, the most recent revision date for
each, and the revision number for each. Does this design seem solid. It
seems that I could group the query by ManName and then somehow filter to only
show the most recent? Thank you in advance for any help or tips.