It might be worthwhile running a find duplicate query on the tables,
and try and find the duplicate fields that you are trying to set as
primary key.
Orders should be related to Purchases.
So you are going to need to create a table that has your orders,
then a table that has purchases, but with a field that relates back to
the orders table.

Does this make sense?

Regards,
Anthony Moore