I have this idea for a Star Trek like game with a focus on story...
What I want to do is present the player with 33 characters and from that 33 let the character choose about 7 (these numbers would actually increase over the course of the game) and assign them to the individual stations as they like and send in to try to promote rankwise them as they like.
The characters have different skill strengths and weaknesses would find and report different things. That seems easy enough.
But I also want the characters to interact with each other and develop with each chapter.
The simple programming side of me says that the easiest way to do this is to just have a database with some sort of emotion calculator for every character they could possibly meet, but that limits what you could possibly do with those characters from a story telling position.
The story telling side of me would want to get in there and tell the story of every character possible, but even with 33 characters that's 1089 possible combinations. with just selecting who to come with. And even doing it this way there are still problems with rank promotion, because let's say you have a character that is with you since chapter 1 and all the other characters that are like that have been promoted several times over, but that 1 has not. You'd think they'd put in for transfer and be ever more hostile, but as the writer there is no way you could know that so you would have to account for it and every other possible interaction they could have or dismiss while writing the chapter which would lead to a lose of immersion.
Perhaps a solution I just thought of, might be "emotional events" seperate from the main story where there is an emotional level for each character and then that would trigger an event if it reached a certain point that you might be able to account for, but even doing that, even with the small band we'd be talking still a lot of things that need to be taken into account such as if 2 characters got married and there is a debate about what to do. Professionally they might want to speak their mind but because they're married to a character who just proposed something, might not... or if they did that would cause friction.
So... you think this idea is too complicated to be done well, or have any suggestions on how to solve these problems, other than just removing it all together?