Creating new table with fields from existing ones....

[Hunter]

I am attempting to combine selected fields from 3
different tables so that I can output the result to an
Excel file, thereby allowing me to import into ACT! as
one database.

Ex: Contact table has 2107 records, and Company table has
3498 records, and the table that relates contacts to
company has only 1894 records. I need a new table which
has 2107 records with contact AND company information.

Is there a way I can do this with a query?

Is there an easier way to just create a 3rd table with
fields from existing ones? Help!

 

[fdelker]

Create a new query with the Contacts table and the
Company tables included. Create a relation (join)
between the two tables based on the key element (company
name maybe?). Right click on the relationship, and
choose "Join Properties". Select "Include all from
Contacts, and only those from Company where the joined
fields match." That should give you 2107 records.
Frank