Curtis,
Thanks, that almost got me there. But, for the jpg_dir variable, however this string looks is how it's updated in the table. For example,
if it's like this in the variable:
jpg_dir = r'P:\GIS_Highway_Dept\Applications\Sign Inventory\Photos\CH01'
then it's updated like this in the table:
P:\GIS_Highway_Dept\Applications\Sign Inventory\Photos\CH01\2410765.jpg
The problem is 2410765.jpg is County Highway 24, as the first two digits in the ID is the highway number. So, that jpg isn't linked correctly, and neither will any be unless they begin with 01 (in the CH01 folder).
Do I have to iterate the Photos directory first and create a list or library, as Randy pointed out?