We have several hundred drawings that we are going to be migrating into PDM. I am setting up the revision table integration, to pull the %user% into the approved by section. The problem I am running up against is that the rev. tables that we currently have on our drawings just contain a field labeled "approved" so when I update the rev, the approved by doesn't autofill. I could simply change the "approved by" variable to match the column name, but the all the old approved by note links would break.
I am familiar with but have not mastered the rev table and corresponding integration with PDM, so please correct me if I am making any false assumptions.
Thanks in advance for your help!