combining two databases in act3

[Patti Fort [Symantec]]

On 28 Sep 1998 19:46:32 GMT, Lloyd Dyer <xLd...@compucom.com> wrote:

>I would appreciate your assistance in combining two databases (with a
>one to many relationship) on say the contact id field, in a third
>database where instead of one record for each contact activity we
>have one record per contact, with the multiple entries in the second
>database, appearing as column entries instead in this third resultant
>database.

Hello Lloyd,

Create a new database and import the two databases into the new one.

In the Import Wizard Panel that asks what type of contacts you want to
import, select Options and specify how ACT! is to handle the various
types of data, Contact Records, Notes/History, Activities, and Group
Records.

You can set the merge criteria, what data is used to determine if
contact records match in Edit, Define Fields. Click the Advanced Tab.
At install ACT! sets the match fields at 1. Company, 2. Contact and 3.
Phone.

Let us know if there are any other questions we can help you with.

Patti Fort [Symantec]
ACT! Technical Support
Symantec Corporation

Please continue to post your messages to the public discussion groups
as Symantec does not provide support via private email.

If you have difficulty getting a response, please read the following
article:

http://service1.symantec.com/SUPPORT/sharedtech.nsf/docid/1998527114414

For free technical support newsletters, Knowledge Base support
articles, our Online Support Genie, and FAQs, visit our ACT! support
page:

http://www.symantec.com/techsupp/act.html