No "repair" facility exists. Suggest you back it up, create a fresh new database, drag and drop everybody from the problem database to the new one and then assess your benefits and/or losses.
OK, just created new empty database, dragged myself and everyone else over and lo and behold, the guy now shows an occupation in his individual summary. His wife now also contains all her info in the proper place in her individual summary. Now, to explore a bit and see if it's all "fixed" and the other stuff intact. Thanks so much for this suggestion. And for the rest of you who offered to take a look at the database - I may yet be in touch. Thanks again for the great support.