HELP on relationships!!! 1

[wargod1999]

I have three tables
company
people
notes

company is unique and has a primary key
there are many people per company so their ID is not unique
there are many notes per person so that ID isn't unique eithger.

for some reason in my form if I goto data sheet view it looks like this:

Note1--->Person1
Note2--->Person1
Note3--->Person1

thats 3 records when it should be one record

Person1--->Note1;Note2;Note3

its showing 100 of the same person when I want just one record per person. Can you help me???

 

[VBslammer]

Tables

Company
---------------
CompanyID PK
CompanyName


Person
---------------
PersonID PK
PersonName
CompanyID FK

Notes
---------------
NoteID PK
PersonID FK
Note

Structure your tables similar to this which will allow the company to have many people, and each person to have many notes.

If you have people working for more than one company then you'll have to use a junction table between the company and person tables.

CompanyToPerson
----------------
CompanyID PK
PersonID PK


Later,

VBSlammer