Working on our upgrade and wanted to see if anyone had experience bringing SO Detail UDF's over from an older version. We've got our Detail file in place in 4.5 and have defined our UDF's (now that we can do that in the actual Detail table!).
My problem is matching the index for the old detail record format to the new. The old uses a (excuse my terminology) "Relative" method (each detail line has a "LinkToPrevLine" and a "LinkToNextLine" to show the record's relative sort order). Some of the Sales Orders have as many as 81 lines.
Is there an easier method than coding a sort routine? Working in Access to build this import file. Stumped as how to proceed.