VMD ordering should be flexible in forms: a few options and fall-back
VMD should have versioning information printed on the datasheets. This may help sort out weird issues.
Ordering is important, so the entry tool should have several options that have historically been used (TreeLineID, stemIDCode, and NewOrder= nz(alternateOrder,treeLineID). If none of those work, a fall-back option could exist where you type the printed stemIDCode and then it finds that row and you type in the information.