database design basic help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...
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
 
Back
Top