This data was imported from another format.  Someone else will be taking care of it before importing it into SQL.  Thanks! I definitely learned something about the order of tables.