database design basic help

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?

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)



"als0107" wrote in message
...
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?

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

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