N
Niklas Östrergren
Hi!
I have earlyer, last week, posted a msg "Normalization" in which I asked two
Q. One of them is now solved but I still have one small problem left. But
first of all I have to inform you about my new tablestructure so far. Which
is a little bit different since last week.
The db I´m working on is a membership db storing information about an
associations member. But since we sometimes also work with people outside
the association we also store some data about them as well (addresses,
phonenumbers and e-mailaddresses).
In the association we have 3 different types of memberships which a person
can pay for. One of them is "Famylymember". This type means that several
persons in the same address can join as a member together for less money
then if they where joining stand alone. The criteria for this is that they
live in the same address. This part is solved!
Now to my problem:
One of the persons in the family is automaticly becomming the [MainMember]
so I would like to use his/her´s membernumber to link the family together.
Ex. If I have memberno 103 and my wife have memberno 120 I would be
[MainMember] and therfore will we (togeher as a family) be family no. 103.
The problem I have is that I havn´t figured out where to store this data
[MainMember] and [FamilyNo].
My table structure looks like this (O = ONE, M = MANY):
tblPersonAddress.....tblPerson............tblMemberShip.............tblMembe
r
AddressID (O----M)fkAddressID
.................................PersonID (O---M) fkPersonID
...............................................................fkMemberID
(M--O) MemberID
Street......................FirstName...............StartDate...............
......MemberNo
fkZipCode..............LastName................EndDate.....................M
CardOrdered
etc.
TIA
// Niklas
I have earlyer, last week, posted a msg "Normalization" in which I asked two
Q. One of them is now solved but I still have one small problem left. But
first of all I have to inform you about my new tablestructure so far. Which
is a little bit different since last week.
The db I´m working on is a membership db storing information about an
associations member. But since we sometimes also work with people outside
the association we also store some data about them as well (addresses,
phonenumbers and e-mailaddresses).
In the association we have 3 different types of memberships which a person
can pay for. One of them is "Famylymember". This type means that several
persons in the same address can join as a member together for less money
then if they where joining stand alone. The criteria for this is that they
live in the same address. This part is solved!
Now to my problem:
One of the persons in the family is automaticly becomming the [MainMember]
so I would like to use his/her´s membernumber to link the family together.
Ex. If I have memberno 103 and my wife have memberno 120 I would be
[MainMember] and therfore will we (togeher as a family) be family no. 103.
The problem I have is that I havn´t figured out where to store this data
[MainMember] and [FamilyNo].
My table structure looks like this (O = ONE, M = MANY):
tblPersonAddress.....tblPerson............tblMemberShip.............tblMembe
r
AddressID (O----M)fkAddressID
.................................PersonID (O---M) fkPersonID
...............................................................fkMemberID
(M--O) MemberID
Street......................FirstName...............StartDate...............
......MemberNo
fkZipCode..............LastName................EndDate.....................M
CardOrdered
etc.
TIA
// Niklas