Here is a brain breaker:
We have the following table structures:
company: fields company_id, name, etc.
guid: fields guid, system, primary key.
The first is a standard customer table. The latter is used to link this record with others from other systems, usign a common GUID. so two records...