>Your order only have a date as information? No customer name? No order details?
>
No, no other information. I was thinking adding back the ID since my colleague just told me it doesn't matter, only PK field really matters for sync, but I already re-did everyting, so even though we have VSS and I can go back easily I would have to make a change back in the table.
Let me figure out again if adding ID back is OK.
I do have details in the OrderDetails table (the items with the price).
If it's not broken, fix it until it is.
My Blog