jwatte:a cleverer way would be to do it in a custom model processor. If you name the normal map that goes with the diffuse texture "mytexture.tga" something known, like "mytexture-normal.tga," then the content processor can automatically find and attach the normal texture.
If you want to go this route, check out our Custom Model Effect and/or Normal mapping samples.
Our normal mapping sample actually chooses the normal map filename using a metadata string that we defined in Maya, which is then looked up in the processor, but it would be trivial to change this to use a naming convention like Jon suggests (and probably easier to use that way).
XNA Framework Developer -
blog -
homepage