10-05-2011 04:48 AM
When trying to set preference for contact duplicate checking ,,, I only found 3 custom fields in the lists ,,, not default fields are there and no other custom fields ONLY 3 !!!!!!!!!
Tried to delete the Database Preference file and rebuild the database schema from ACtDiag but in vain.
Any help, or suggestions would be very much appreciated.
Thanks in Advance
10-05-2011 05:37 AM
10-05-2011 06:36 AM
Thank you very much for your prompt response.
I am using ACT! Premium 2008 for Web. I have tested the demo database and the feature is working correctly even after creating new custom fields.
I am afraid my database is corrupted or something like this because we have made too many custom fields and tailoed layouts for it.!
Please Greg note that the only 3 Custom fields that appear in the duplicate cheking list were almost the last 3 added custom fields.
Any other Suggestions?
10-06-2011 09:53 AM
This isn't an indication of corruption within your database, this is actually a known issue within the 2008 product. It is caused by the creation of enough fields to fill up the basic contact field table and create spill over tables. Unfortunately there isn't a way to control which fields will or won't be listed.
If you aren't using the 'User Fields', you may want to rename them to fields to use for duplicate checking. You can try to populate the renamed fields (depending on data types) by using the Edit > Copy Fields command. Again, the custom fields may or may not be available in that drop down.
10-07-2011 04:51 PM
Thank you Greg for clearing it up to me, but I am disappointed to hear that this is a know issue and there's no way to fix it. Is it it solved in the after 2008 releases ?????
I don't think the user fields will be useful in my case because the copy field option will be done to the existing records and there are no grantee that the future records will not contains duplicates. Any way the user fields are not listed in the duplicate checking list. But I have an idea that crossed my mind just now and would like to ask if it will be beneficial or not.
If I have a new database and deleted all the unused fields from it and then add again all the customization we have done before, would this solve the issue of the spill over tables issues!!!!!
Thank you very much for your co-operation and support. Thanks in Advance.
10-10-2011 05:40 AM