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!!!