Re: Approach for multi level organizations

Allen,

Thanks for your input, but mine is maybe not too complex. A member can not
belong to the next 2 or 3 upper level.

A member can belong to a local church, then a church can belong to a mission
then a mission belongs to a Union and a Union can belong to a Division and a
Devision belongs to a General Conference ( World Head Office).

I think what I want to try to make is upto Union. What I plan to make is

1. local church table
2. Mission table
3. Union table.

The table structure is
1. Primary key of local church - Foreign key in members table
2. Primary key of a mission table - foreign key in local church table
3. Primary key in a Union table - foreign key in mission table

my question is, in the mission table office, how can we import the data and
make a consolidation from all local churces

The same is true for office of Union table.


Thanks very much for any help
--
H. Frank Situmorang


"Allen Browne" wrote:

One approach is to use the tables as you have them, so each level is a
member of the next one up, and you can trace them.

An alternative approach is to put all the persons and corporate entities in
the one table of "clients." You can then define the connections between the
various clients, e.g. many people belong to a local church, and so on. This
approach has some advantages and some disadvantages.

A major advantage is that you have only one table to search to find
anything. Similarly, if you have to track things (like who paid for what),
you can just use a foreign key to the client table. This makes it really
flexible, and so I constantly lean towards this design.

The disadvantage is that it potentially makes things too flexible, and it is
possible to enter data that doesn't make sense. For example, you could
finish up with a division that is a member of a local church (which makes no
sense), so you have to take action to prevent this.

For a downloadable example of this kind of structure, see:
People in households and companies - Modeling human relationships
at:
http://allenbrowne.com/AppHuman.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Situmorang" <hfsitumo2001@xxxxxxxxx> wrote in message
news:AAC9687B-A007-43AF-8DEC-E616A26630D5@xxxxxxxxxxxxxxxx
Hello,

I have created for our local churches a membership database. My question
is
what is our approach to make a membership database for the following level
of
our organization (bottom up):

1. Local churches
2. Mission/Conference ( consists of local churches)
3. Union ( consists of Missions)
4. Divison ( Consists of Unions)
5. General Conference (World level) consists of divisions

How can I make a database in the Mission level to be able to import data
from local churches ( note that church database consists of many tables)

The same routine import job is true for the other higher organization,
Union, Division and General Conference

What I have in mind, correct me if I am wrong, in the member table, there
should be a foreign key for Mission table...

Thanks for any idea provided.

--
H. Frank Situmorang


.

Relevant Pages

  • Re: "FreeCEN" highlighted by Yahoo as "dangerous"
    ... As the great Groucho Marx said, I wouldn't want to belong to ... Anyone who wants to pretend that living people must ... Dismissing the forum because you don't agree with one small aspect of the forum is a bit like throwing the baby out with the bathwater. ... So long as the rules and limitations of any group are made clear before someone joins, if they still choose to join, then I can't see that said new member has any grounds for complaint. ...
    (soc.genealogy.britain)
  • Re: Pats Bent Vets
    ... but it is unusual for someone to belong to both ... Mrs P was a a member of the FUW for a while. ... The NFU come out of it as smart, ... Pat Gardiner ...
    (uk.business.agriculture)
  • Re: Scottish politics on Radio 4
    ... I'm a member of The ... You were the one bragging about being a member of Mensa, ... hand not peoples private lives. ... So what organisations do you belong to? ...
    (soc.culture.scottish)
  • Re: Quesry-based Distribution Groups
    ... If only a few people belong to more than one department, ... to a separate "static" distribution group and modify the query on the ... query-based group to include this new group as a member. ... custom attributes and use that as additional filter condition instead of ...
    (microsoft.public.exchange.admin)
  • whenever where marched
    ... soul to which they belong, which loves them better than they love ... The separate member, seeing no longer the body to which it belongs, has only ... in the same way as it is loved by the soul. ... Adhaerens Deo unus spiritus est. ...
    (sci.crypt)