For the last couple years, I have been tossing around an idea for a long-running RP that compiles a list of entries hyperlinked to individual posts for each character in the roleplay to give easy access to certain posts (e.g. easy reading order for new players or a convenient way to find a single post out 1000 IC posts).

When I first tried [url=https://www.roleplayerguild.com/posts/4054164]this[/url], I just typed out the lists by "hand," so to speak. However, I quickly realized that the word document quickly became unwieldy and the process was time-consuming. I needed something a little more automated. I have tried messing with Excel and Microsoft Access to varying degrees of success, but both programs have their limitations. For instance, for both Excel and Access, I had to develop a system to sort the data in those programs and I had to keep entering that sorting data for each individual post entry.

So my question is does anyone have any ideas/suggestions for what's the best way to tackle this project? I would like it to look somewhat like my initial attempt at this project. My ideal optimization/automation would be being able to create only a single entry for each post and tag it with each character that appears in that post so that that single entry will populate each character's list.