So how does this work when you try to save a document from MS Word 2003 up to SharePoint? Quite well actually. When you get to the screen that asks you for your meta-data, you will see a drop down menu of the different content types available in that library.
As you choose different content types, you will see the set of meta-data fields changing. Here is a screenshot of what it looks like:
