Hi,
I'm trying to interconnect several databases using the non-SQL version of DbMan, but I'm not sure of the best way to go about it.
The databases will be used for a Fantasy Sports League that I'm running for my friends.
I need one database that can track user information, one they can sign up for themselves. I need another that tracks the players, where I can enter their scores (this could also become a database itself to allow for an open-ended season). And I need one more to sort of combine the two, that tracks which players were selected for which owners and tabulates their scores on a weekly basis.
I know there are probably several ways to go about setting up the tables, some with more tables that allow for greater flexibility and some with fewer that are easier to manage.
Do you know of a way that I could do this within DbMan? Is there a way I can hack a relational database out of multiple flat files where One database can draw values from querying another?
Any help would be sincerely appreciated!
I'm trying to interconnect several databases using the non-SQL version of DbMan, but I'm not sure of the best way to go about it.
The databases will be used for a Fantasy Sports League that I'm running for my friends.
I need one database that can track user information, one they can sign up for themselves. I need another that tracks the players, where I can enter their scores (this could also become a database itself to allow for an open-ended season). And I need one more to sort of combine the two, that tracks which players were selected for which owners and tabulates their scores on a weekly basis.
I know there are probably several ways to go about setting up the tables, some with more tables that allow for greater flexibility and some with fewer that are easier to manage.
Do you know of a way that I could do this within DbMan? Is there a way I can hack a relational database out of multiple flat files where One database can draw values from querying another?
Any help would be sincerely appreciated!