can you help with amending CM template?

[Guest]

Hi.

I'd like to use this template
http://office.microsoft.com/en-us/templates/TC010178391033.aspx?CategoryID=CT011366681033

but it has been a really LONG TIME since i used Access and forgot some basic
principles of table construction and how to link them ( relationships).
Can some one help by illustrating to me what tables and primary keys i need
in order to achieve my objective listed below?

I need to store more contact names under the same company record, hence i
intend to leave the GENERAL tab just for Company data, leave Calls tab as it
is, but create a separate CONTACTS tab (instead of ADDITIONAL INFO) which
will store and display the various list of employees contacts for the same
company (i.e first names, Last names, email, job title etc).

it should be straight forward but my brain has just gone blank and any help
would be appreciated.

Thanks

 

[tina]

you need a tblContacts, which will include the fields that describe a
contact (first name, last name, job title, etc). add a foreign key field to
hold the value of the primary key from the Company table, so that each
contact is linked to a specific company. (btw, if a single contact may have
many phone numbers - work, cell, pager, for instance - then you may want a
separate table linked to tblContacts, to hold the phone data.)

hth