>Think I got it, needed to do a reindex.
>
>Thanks All!
>Sunshine
You may want to take a look at Stonefield Database Toolkit http://www.stonefield.com

This tool does a terrific job at reindexing tables and making sure everything in the DBC (primary keys, relationships) is kept.