Automate tags like a relational database

Hello
Imagine I have 3 files:

  • company.md
  • character.md
  • product.md

than the company.md file
contains a template like

-Company
–company_name
–product
–character

-Character
–Character_name
–product
–company

-Product
–Product_name
–character
–company

And that in a random file I write

Windows was invented by Bill Gate with his Microsoft company in 1975

I would like to do something like
[Window]-(#productName) was invented by [Billgate]-(#characterName) with his company [microsoft]-(#CompanyName)

Which then automates writing microsoft to the company.md file and so on.

Do you what i mean ?

I encourage you to take a look at this plugin as it partially does what you describe and more GitHub - brianpetro/obsidian-smart-connections: Helps you stay organized by using OpenAI to display the most relevant notes in your Obsidian vault in real-time.