F
Frank Situmorang
Hello,
I have 2 tables of our church membership, member table and addrfess table
In member table there is a foreign key of address table. When we come to
append this table in the higher organisation, the primary key of address will
conflict with the primary key of another church's address table. I have an
idea to keep the address primary key is always uniqueI want to make an
acronym alpha numeric. Is it posible to make an autonumber of addess table to
be alpha numeric.
Or my question how can we handle the uniqueness of the address primary key (
autonumber) so that when we come to an cosolidation of all churches member
table, the address is also can linked in the consolidation, so we still keep
track the address of all members in the Regional office of the church.
We appreciate your any idea provided.
Thanks in advance,
I have 2 tables of our church membership, member table and addrfess table
In member table there is a foreign key of address table. When we come to
append this table in the higher organisation, the primary key of address will
conflict with the primary key of another church's address table. I have an
idea to keep the address primary key is always uniqueI want to make an
acronym alpha numeric. Is it posible to make an autonumber of addess table to
be alpha numeric.
Or my question how can we handle the uniqueness of the address primary key (
autonumber) so that when we come to an cosolidation of all churches member
table, the address is also can linked in the consolidation, so we still keep
track the address of all members in the Regional office of the church.
We appreciate your any idea provided.
Thanks in advance,