OK. I'll go to the bottom of the nerd's class 🙁
See if this works better
There are locations (Dealers) that represent a Car Dealership that sells cars. The code for the dealer is varchar(10) containing 6 numeric digits where thr first 3 are zero (eg 000123) this I cannot change due to external systems however it is possible to convert the last 3 digits to int but this would constrain the system if this ever changes but I am prepared to accept this for an easier solution
At these locations, a Dealership enter details of a Contact they will be making with a Customer, e.g. name, telephone details etc
Associated with this contact is:-
a SalesExecutive (or Sales Person if you like) at that Dealership
an Outcome (Sale, Lost Sale etc)
the Source of the contact (Direct Mail, Local Awareness etc)
the Model (of car) the are interested (at this time Dealerships can enter their own description not sure if this will change to dedicated central list)
the type of Contact (Walk-in, Telephone etc)
Dealerships will maintain their list of names of SalesExecutives, Models etc
p.s. This data is currently held discreetly at Dealerships and will be in future stored centrally
Far away is close at hand in the images of elsewhere.
Anon.