Hi,
My installation of GeniusConnect writes to a sql 2005 database. Everything syncs fine as long as we let the sync run automatically at set intervals. If anyone clicks on Store All, all of the outlook contacts are written to the database instead of being updated. This results in duplicate values with new keys.
To set the linking field I set a mandatory key using this command:
select (max(repID) + 1) from repFirms.
We really need some help with this becasue this data is tied to other applications.
Thanks,
--Geri