Contact Tracking Database 1

[mcaoneill]

Yikes, I am not even sure where to start. I am creating a database for tracking all contacts with companies, so far I have created two tables, one for companies with the company ID, company name and website. I have also created contacts, with companyID, contactID, name, address, phone and e-mail. This is a one to many one company to many contacts. Each contact could be in a different location to the company that is why the address info is in that table. I also need a calls table to track date, time, contact person and pertinent information regarding the call, and finally I need to track any articles written about the company. I am thinking for the articles, just associated it to the copmany table with company ID. The call's table is where I am tripping, do I associate the calls table with the company or the contact?

Also is there a way to link the company ID in companies and the companyID in contacts automatically by company name in contacts?

Does this make any sense???

Thank you

Maureen

 

[Golom]

I would associate calls with the contact. You can always link the contact person back to the company but you can't link to a specific contact if the only relationship that a call has is to a company.

Linking Contact to company should work like this
[tt]
Select Company.Name
From Company INNER JOIN Contact
ON Company.CompanyID = Contact.CompanyID
Where Contact.ContactID = "ABC"
[/tt]
and substitute whatever you want as the variable that contains the ContactID information.