Hello,
I am trying to create an Access database that will have an individual record for each enslaved person at a former tobacco plantation. In addition to biographical information that will require only one entry (first name, last name, gender, birth date, etc...), I need to be able to add multiple family members (as they are discovered) and multiple events that occurred during that person's life.
For example:
Relationship (choice from a lookup list: mother, father, son...) Relative's First Name (this person will also have an individual record in the database) Relative's Last Name
Relationship (choice from a lookup list: mother, father, son...) Relative's First Name (this person will also have an individual record in the database) Relative's Last Name
Relationship (choice from a lookup list: mother, father, son...) Relative's First Name (this person will also have an individual record in the database) Relative's Last Name
Event (choice from lookup list: manumitted, escaped, childbirth...) Event Date Event Description (text field)
Event (choice from lookup list: manumitted, escaped, childbirth...) Event Date Event Description (text field)
Event (choice from lookup list: manumitted, escaped, childbirth...) Event Date Event Description (text field)
Wise ones, can you help me with this? There will be multiple relatives and events for some people and my questions are:
- How do I avoid having to create a bunch of fields like Relationship1, Relative First Name1, Relative Last Name1, Relationship2... and Event1, Event2, etc... ? I could have the Relationship and Event choices be multi-selection and then have one text field for Description, but that's so messy.
- How can I set these up so rows would be added as relatives and events are added?
- What relationships do I create between the main table of biographical info and separate "Relatives" and "Events" tables or subforms?
Sorry for the long post! I hope you can help and really appreciate any input.