Hi friends!
I know this will sound strange, but need help setting up a table(s) for following:
I want to make a genealogy program in MS Access. Now this I know how to do. One table of people with a field for father code and a field for mother code which would be filled with the corresponding codes of the people in the table that are the mother and father. But in my project each individual can have multiple mothers and fathers! (don't ask why at this point🤪.
And this possibility continues as we go back, higher up the family tree.
How should I setup the people table(s)?
Thank you very much!
Susan Flamingo