My personal idea to designing the databases is to make their layout simple and easy to comprehend
Each to his own...

I would at least add another column to both tables, called ExpiryDate. Whenever a new Revision is inserted set its ExpiryDate to Null and then set the ExpiryDate of the previous record(s) to the current date. You could then query using "Where ExpiryDate Is Null" which ensures you only get the "current revision records" and you won't need any of the running totals or suppression of sections in Crystal.

Simple and easy to comprehend.