Please help! I cant figure out my relationships!

[Harold via AccessMonster.com]

Hi,
I have three tables. I am trying to make a database that tracks building
systems that are out of service. I thought I could link the tables by the
AddressID field. There can be only one address for each business or event,
but there can be several businesses and several events at each address. So I
thought that I would have a one to many relationship between the Business
(many) and Address (one) and the same with the event and address. When I try
to set up the relationship it sets up a one to one. Is that what I need? If
not how do I set up the right relationships? Do the Business and Event table
have to have a relationship set up or will the fact that they are both linked
to the address table be enough?

I can't seem to grasp the relationship part of Access.

tblAddress
AddressID - Primary key
StreetNumber
Direction
StreetName

tblBusiness
BusinessID - Primary key
BusinessName
BusinessPhone
ContactName
ContactPhone
AddressID - Foreign key

tblEvent
EventID - Primary key
DateTimeOS
DateTimeIS
Reason
SystemType
DownTimeEst
Notes
CalledOSBy
AddressID - Foreign key

Thanks,

Harold

 

[tina]

in tblBusiness and tblEvent, make sure that the AddressID field's Index
property is *not* set to Yes (No Duplicates), and make sure that the field's
data type is *not* Autonumber - if it is, change it to Number, Field Size as
Long Integer. after you've done all that, open the Relationships window
again, and try linking the primary/foreign key fields.

beyond that, i can only urge you to study and learn the basics of relational
data modeling before going further in your database development. designing
the tables/relationships correctly is crucial, and well worth the time you
must invest in doing it. see Database Design for Mere Mortals by Michael
Hernandez, and numerous helpful links at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html
beginning with the Starting Out and Database Design 101 links.

hth