I normally add a parameter. Set the text label to ".Revision". Under Project Options, Parameters tab, create a "Revision" parameter, with value "1" (or whatever your current revision is).
Use the same parameter on schematics with "=Revision".
I'm not sure if parameters can be referenced from database or anything. (If you want to write a script, anything is possible?)
Tim