How to Use a Relational Database for Genealogy

Today's episode of Research Like a Pro is about using a research log to track your DNA research. We discuss spreadsheets and databases as the optimal tools for your research log, and discuss Airtable as a possible relational database that you can use. We talk about various sheets/tables to include in a DNA research log and how you might want to organize the columns in each table.

Links

Crème de la crème: Targeted Autosomal DNA Testing to Isolate Pertinent Genetic Cousins - by Paul Woodbury at Legacy Family Tree Webinars - https://familytreewebinars.com/webinar/creme-de-la-creme-targeted-autosomal-dna-testing-to-isolate-pertinent-genetic-cousins/ 

John Royston’s Orphan: Lucky Winner of the 1827 Georgia Land Lottery - https://familylocket.com/john-roystons-orphan-lucky-winner-of-the-1827-georgia-land-lottery/ 

Airtable Universe - Nicole's page - https://www.airtable.com/universe/creator/usrsBSDhwHyLNnP4O/nicole-dyer 

RLP with DNA 2023 base - this is updated each year but was originally made in 2022 - https://www.airtable.com/universe/expy4V9HzRUxtJLvh/rlp-with-dna-research-log-2022

Airtable Research Logs by Nicole Dyer - https://familylocket.com/airtable-research-logs/ 

RLP 240: RLP with DNA 3 – Organize Your DNA Matches Visually - https://familylocket.com/rlp-240-rlp-with-dna-3-organize-your-dna-matches-visually/ 

DNA Research Logs: How to Keep Track of Genetic Genealogy Searches - by Nicole Dyer https://familylocket.com/dna-research-logs-how-to-keep-track-of-genetic-genealogy-searches/ 

Sponsor - Newspapers.com

For listeners of this podcast, Newspapers.com is offering new subscribers 20% off a Publisher Extra subscription so you can start exploring today. Just use the code “FamilyLocket” at checkout. 

Research Like a Pro Resources

Airtable Research Logs Quick Reference - by Nicole Dyer - https://familylocket.com/product/airtable-research-logs-for-genealogy-quick-reference/

Research Like a Pro: A Genealogist's Guide book by Diana Elder with Nicole Dyer on Amazon.com - https://amzn.to/2x0ku3d

Research Like a Pro Webinar Series 2023 - monthly case study webinars including documentary evidence and many with DNA evidence - https://familylocket.com/product/research-like-a-pro-webinar-series-2023/ 

Research Like a Pro eCourse - independent study course -  https://familylocket.com/product/research-like-a-pro-e-course/

RLP Study Group - upcoming group and email notification list - https://familylocket.com/services/research-like-a-pro-study-group/

Research Like a Pro with DNA Resources

Research Like a Pro with DNA: A Genealogist's Guide to Finding and Confirming Ancestors with DNA Evidence book by Diana Elder, Nicole Dyer, and Robin Wirthlin - https://amzn.to/3gn0hKx

Research Like a Pro with DNA eCourse - independent study course -  https://familylocket.com/product/research-like-a-pro-with-dna-ecourse/

RLP with DNA Study Group - upcoming group and email notification list - https://familylocket.com/services/research-like-a-pro-with-dna-study-group/

Thank you

Thanks for listening! We hope that you will share your thoughts about our podcast and help us out by doing the following:

Write a review on iTunes or Apple Podcasts. If you leave a review, we will read it on the podcast and answer any questions that you bring up in your review. Thank you!

Leave a comment in the comment or question in the comment section below.

Share the episode on Twitter, Facebook, or Pinterest.

Subscribe on iTunes, Stitcher, Google Podcasts, or your favorite podcast app.

Sign up for our newsletter to receive notifications of new episodes - https://familylocket.com/sign-up/

Check out this list of genealogy podcasts from Feedspot: Top 20 Genealogy Podcasts - https://blog.feedspot.com/genealogy_podcasts/