Thanks, Peter. That was the little bit I was missing and the update was simple since we haven't loaded production data yet so I just edited the data in SQL Server management studio.
For a future enhancement, perhaps DMX could ask for confirmation when someone atempts to load a file for which no type has been defined yet. The message could point out that, if the type is added later then a database query to adjust the entry will be required. This would give the user a chance to step back and put the file type into DMX before proceeding.
I'm sure there are many more important things to do, but it would be helpful to not inadvertently create a situation where a database adjustment becomes necessary.
Thanks again,
Bruce