I’m currently in the process of creating a Game Design Document (GDD) in Obsidian, and I’m looking for a way to effectively manage table relationships. In my GDD, I have macrocategories and subcategories that I’d like to organize as columns in a relational database.
In my first database (Database A), I have a “Macrocategories” column with options such as “Characters,” “Items,” and “Levels.” I’d like to create a second database (Database B) with columns for each of these macrocategories and automatically populate them with corresponding subcategories from Database A.
I’ve explored using the Dataview plugin, but I’m seeking a more automated method for handling these table relationships.
I tried looking for the answer on pages and pages of Google connected to the DBfolder and Dataview plugins, I even looked for the answer by querying ChatGPT but nothing.
Does anyone have suggestions or know of a plugin that might help me achieve this goal?
Thank you in advance for any assistance or advice!