Re: PK & FK problems in data consolidation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Michael, yes I understand a bit aobut your jargon...he...he..he.I am
not an English speaker...so maybe that is one reason that I run in the circle.

I agree with you that it should be using a multi field primary key, but
what bothers me I think it is difficult to operate.

Rignt now I have an input form of a member and in this form I have a combo
box to choose his address. With this 4 field PK of address, how can I make it.

When I input the member ID with the 4 field PK, how can I do it. Isn't it
too complicated for a church secretary to operate?



Thanks for your advice
H. Frank Situmorang


"Michael Gramelspacher" wrote:

On Thu, 30 Oct 2008 00:30:05 -0700, Frank Situmorang <hfsitumo2001@xxxxxxxxx> wrote:

Tom...my problem is quite complex chruchID within the region yess. it is not
duplicate, but as I said in my other postings, that our organization is is a
multilevel,
The highest is GC ( General Conference) which is a world office which is
consist of 13 Division, then Division consists of Union and Union consits of
Region. Like us in Indonesia is part of West Indonesia Union, and Union
consits of Region, the Region consists of Churchses

Yes your suggestion could be right if the churches for the region, but if
the church is in another region, of course their churchid sould start also
from No.1

The same is true fo the RegionID, if it is in the other Union, the RegionID
should start also from no.1, so there will be a duplicate regionID from other
Union (upper level). The same is true also for the UnionID, will duplicate
with the other UnionID from other DiVisions, This is not the case with the
Division because only one office for the world level, and I have got its
Acronym and can be used as it's ID

I do knot know if Access database can handle this kind of hirarchy, each
herachy will consolidate the data from it's lower offices.

Thanks for any idea

You are running around in a circle like a dog chasing its tail and getting nowhere.

Members table and Addresses table at all levels can have the same structure. The key will be
MemberID, ChurchID, RegionID, UnionID, DivisionID, that is, a multi-column primary key. Everyone is
happy. Everyone's member table structure is the same as everyone else's. Same goes for addresses.

I assume each church is not making up their own RegionID, UnionID and DivisionID numbers. Do
regions make up numbers for their churches? Do unions make up the numbers for their regions, etc.?

.

Relevant Pages

  • Re: {OT} Detroit Automakers a Relic of the Past
    ... I am not compelled to pay "church dues" but I am compelled to pay union dues. ... The union takes my money and supports candidates and positions I do not agree with, the evangelists do not take my money to support candidates and views I do agree with. ... Unions give me very little, I disagree with them on a very fundamental level, but if I work in certain trades, I have no choice but to become a union member. ...
    (alt.autos.toyota)
  • Re: Click...
    ... 1990 Trust, 3E Foundation, Abaana, ACEVO, ACORD, Action Aid, Action Against ... ADRA-UK, Advantage Africa, AERDO, Afghanaid, Afghan Poverty Relief, ... Bakers, Food & Allied Workers Union, The Balcraif Foundation, Banana Link, ... Development, Church of England, Church Mission Society, Church Mission ...
    (alt.lang.asm)
  • Re: cheating on spouse
    ... We learn discipline often by failing to use self disipline. ... I was a member of a fairly popular church at least in the ... God allowed Satan to tempt Job, ...
    (soc.religion.mormon)
  • Re: Warning comes when using Unions
    ... I have declared an Union as follows ... member of a structure with more than one named member may have incomplete ... The expression that specifies the width of a bit-field shall be an integer ... declarator. ...
    (comp.lang.c)
  • ATI driver compilation problem
    ... I tried the ATI driver as supplied by ATI and the one supplied by livna ... member `pgd' in something not a structure or union ... defaults to `int' in declaration of `drm_agp_module_stub' ...
    (Fedora)