Sports database/relational help

[kwarren]

I need some advice from those of you who use relational databases. I'm very familiar with FileMaker 5, but have limited experience with relational databases.

I want to create a solution for our newspaper that will allow our sports clerks to type in statistics from sporting events that I can then export to our Quark Publishing System.

I have created a database with team name, player first and last names and position. In another database, I have 2 conditional value lists that let me select the opposing teams from that first database and display the rosters in portals. That works fine. But how do I handle the stat information from each game? Would that be in a third database?

[LiveOak]

Sounds like a good idea to me, maybe it would be "Games". It could really be two additional files: Games and Stats.

-bd