Many to Many Relationship

Ask for Help
1

Hi,
I’m a beginner in dealing with databases and I’m not a programmer.
I am working on a historical & genealogical research database to input information from original documents, analyze the data and come up with tasks for further research.

I currently have the following tables:
Documents: form capturing the information from the documents
People: all people that appear in a document
Places: All locations mentioned in a document

There are many other tables but I’ll limit it to these for this question.

There are usually multiple people and places mentioned in a document. So there will be many people referenced in many documents. Same with the other tables.
I thought of a linking type tables. documents - people, documents - places, people - places, etc each referencing the other.
Is that a way to do that?
If so how can that happen without me manually connecting each one each time I enter a document?

Am I even asking the right questions?

Please ask for any other detail that you need for clarification.
Thanks,
Glenn

2
1 Like
3

Thanks! Let me play with that to see if it does what I’m thinking.

4

You don’t have the exact task

  1. If: Document have many Peopels and same doc have many Places but People no have relations to Places in this Doc.
  2. Or: Each Document have rows (dates for example) where each row for this document have info about 1 Place and 1 People in this place?
    In this case we totaly know In wich doc and when(dates) and where(Place) was this one Person.
  3. Or another?
5

I’ll share more after I finish with the tutorials. That will probably clear things up in my mind before I try to have someone explain things that the the tutorials cover.
Thank you!

6

Feel free to just make an example in Grist and link here.
This will save time on correspondence.