Need to correct relationships

[msmithtlh]

I have incorrectly created the relationship between 2 tables: individuals and congregations and can't seem to fix it.



There can be many individuals in a congregation. Not all individuals will be associated with a congregation.

I'm thinking this makes the relationship

congregations to individuals
one to many

Enforce referential integrity ???

If I correct this in the relationship model, is there anywhere else I need to correct it? Queries?

Thanks!!!

[ArviLaanemets]

You need:
1. Table of individuals, like tblIndividuals: IndividualID, ForeName, LastName;
2. Table of congregations, like tblCongregations: CongregationID, CongregationName;
3. Table like tblCongegrationMembers: MemberID, CongregationID, IndividualID.

In case you want to set relatioships, you have to set relationships between tblCongregationMembers and tblCongregations, and between tblCongregationMembers and tblIndividuals.