- Local time
- Today, 08:12
- Joined
- Jul 9, 2003
- Messages
- 17,511
I have been looking at a database which is in essence a flat file type. It contains references to next of kin, father mother spouse etc. I think these items could be put into a new table called "tblNOK" (next of kin)
The basic information stored would be something along the lines of ID, Surname, Middle, First, Date of Birth.
Now this is the interesting bit, I thought I could link the next of kin to the principle person with a many to many table. And in that table I could also have an extra field that denotes the relationship. I wondered if anyone else had any views on this.
The other reason I am asking, is that I have seen some genealogy tables, and I realize there are some special codes used to denote links between relations. I am thinking I don't wish to reinvent the wheel!
Any comments would be greatly appreciated.
The basic information stored would be something along the lines of ID, Surname, Middle, First, Date of Birth.
Now this is the interesting bit, I thought I could link the next of kin to the principle person with a many to many table. And in that table I could also have an extra field that denotes the relationship. I wondered if anyone else had any views on this.
The other reason I am asking, is that I have seen some genealogy tables, and I realize there are some special codes used to denote links between relations. I am thinking I don't wish to reinvent the wheel!
Any comments would be greatly appreciated.