database design basic help

[als0107]

I am new to database design and have a basic question about how to set it up..
I am trying to create a database for media information. There will be multiple contacts (reporters, editors, etc) from each company. Is there a way to have the main company information remain the same for each seperate contact and update automatically when one is changed?

 

[Van T. Dinh]

Yes. That's how you use database "relationally".

Basically, you have 2 Tables: 1 for Companies and 1 for Persons. You
create a One-to-Many relationship between the Companies Table and Persons
Table, in a way, saying that a Company can have many Staff.

Check Access Help / Access books on One-to-Many relationship. Also on the
Many-to-Many relationship just in case this is more suitable for you.

--
HTH
Van T. Dinh
MVP (Access)

I am new to database design and have a basic question about how to set it up...
I am trying to create a database for media information. There will be

multiple contacts (reporters, editors, etc) from each company. Is there a
way to have the main company information remain the same for each seperate
contact and update automatically when one is changed?

 

[Jessestonecedar]

when creating the two tables, use the autonumber in companies so that the field
name would be Company!id. In the persons table, have a field called Company
which holds the id. Company!id would be the primary key in company. In persons,
the field Company should be indexed non-unique. In tools->Relationships, create
a one to many link between Company!ID and Persons!Company. When you browse, the
links will be accessable through the plus sign for each company showing all
persons for that company.

Rich

 

[als0107]

Thank you for the suggestions! Very helpful! I appreciate your time.