OK I made this humongous flat sort of table with every kind of imaginable field in it. Now I need to normalize the thing but get the results as easily as if it were one table. My question is just how deep do you go in the process.
I have an entire family tree as well as will assignments I can see clearly a one to many relationship here as family members can wear many hats in the assignments but the assignments only have one person at a time unless they are shared which would be designated as a co-assignment. My question is if I have fields like child1, child2 ---to Child8 the same for grandchildren that include things like birth date, age, SSN as well as text features depending on the gender field his/her him/her he/she. Should I make a separate table just for children or another for boys and then girls? I need to count boys and girls and all the children as well. Which is tricky when I want to update them. But my question is about normalizing and I see that I have a big mess with what I have got eventhough it more or less completes its mission.
How do I get from the individual records only the fields that have been assigned in the process into a single table? Result table. This is important because I need to make a merge to a wordprocessor. I haven't figured out if Alpha can generate an index on a report which is a whole different issue. So I am still looking at merging through a wordprocessor to print and modify the wills.
Any insights or help with this would be immensely appreciated
Sincerely George R. Kenney
I have an entire family tree as well as will assignments I can see clearly a one to many relationship here as family members can wear many hats in the assignments but the assignments only have one person at a time unless they are shared which would be designated as a co-assignment. My question is if I have fields like child1, child2 ---to Child8 the same for grandchildren that include things like birth date, age, SSN as well as text features depending on the gender field his/her him/her he/she. Should I make a separate table just for children or another for boys and then girls? I need to count boys and girls and all the children as well. Which is tricky when I want to update them. But my question is about normalizing and I see that I have a big mess with what I have got eventhough it more or less completes its mission.
How do I get from the individual records only the fields that have been assigned in the process into a single table? Result table. This is important because I need to make a merge to a wordprocessor. I haven't figured out if Alpha can generate an index on a report which is a whole different issue. So I am still looking at merging through a wordprocessor to print and modify the wills.
Any insights or help with this would be immensely appreciated
Sincerely George R. Kenney
Comment