Sorry this is already on the list but just using our emails to highlight the problem further. We have an issue with using email as primary key. Two examples - Firstly, in how it relates to our (many) businesses that have two owners (say husband and wife) they both use the same email address but have different requirements of us, one might need finance training one might be management. We want the history of both as they are two different people, two differnt interactions, two different member contacts but using the same email address. Secondly, we have a lot of users who don't permanently work on a computer (warehouse, gardeners, science lab techs etc). They may have ONE email address for an area e.g. orders,@xyz or admin@xyz or room44@xyz but several people use this as their work contact. How do we track all those individuals now 😞 In our original system we could, now we are in the midst of migrating and it is going to be tough.
...read more