Hi, I started a thread on 9/12 titled "products disappear from categories". My problem is that products become unassigned from categories. It was suggested that the Catxprod table is corrupted. Bill Weiland posted that "The record for that product in that category should still exist in the cxp file. The orphaned records problem was when a category was deleted and it corresponding records in cxp were not deleted. Burch posted a query to fix both that and the catcount variable in the product record. " I was hoping he meant you and that you could steer me to your method to correct this. Thanks, Brent