I wish I could explain this one...
I have HQ & four stores.
These are real examples.
HQ Item Table: ID ItemLookupCode Description
2505 29464/D827022 RECLINER, LZBOY
3503 29464/D827022 RECLINER, LZBOY
406 45202/WACOCOA LOVESEAT, WARNER COCOA
7044 45202/WACOCOA LOVESEAT, WARNER COCOA
3144 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE
3204 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE
Store #1 Item Table: ID, HQID, ItemLookupCode, Description
4631 2505 29464/D827022 RECLINER, LZBOY
2505 2505 29464/D827022 RECLINER, LZBOY
9140 0 29464/D827022 RECLINER, LZBOY
9141 0 29464/D827022 RECLINER, LZBOY
406 7044 45202/WACOCOA LOVESEAT, WARNER COCOA
7042 7044 45202/WACOCOA LOVESEAT, WARNER COCOA
9144 0 45202/WACOCOA LOVESEAT, WARNER COCOA
9145 0 45202/WACOCOA LOVESEAT, WARNER COCOA
3255 3144 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE
3175 3144 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE
9142 0 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE
9143 0 AUNATURALLE/Q MATTRESS, QUEEN, WICKLINE
All four stores have these six items with HQID = 0.
I have re-indexed both HQ and Store DBs.
What do I do to fix this? Tom