I need some advice I need to create a database Global for my company which have a lot suppliers coming from all over the world. I need to create this database base on each location( sample USA, CANADA, UK, ASIA, AUSTRALIA)... I already have tables from all over the places with manufactures, distributor an extra info..My question is how can I set a primary key for each location supliers so all tables are not auto (01,02,03) and how can I build a relationship and run querys .
How can combine all and not show no repeats because some of the suppliers are repeats in some tables like for example USA and Canada may have some similar supplier.
Thanks for any advice hot to start this Monster!!