Need Help w/ Personell-Scheduling DB

[ronkmd]

Hi,

I am trying to develop personnel-scheduling database for my Anesthesia practice. This can be looked at as a baseball team, where each player is assigned to a different position each day. There are more players on the team and positions, so some players will either be off or on vacation each day. I'd like to be able to go back and tabulate how many times in the year each player has played each position, as well as how many times each player has pitched on the weekend. I'm having trouble conceptualizing the setup and relations for this. I have a table for Players and a table for Positions. Could somebody please give me some guidance on how to proceed from here? Thanks!

Ron

FileMaker Version: 7

Platform: Windows XP

[Kurt Knippel]

Well, ok so you have Player and Position, then you need a join file, call it Day.

Player:

PlayerID

PlayerName

etc..

Position:

PositionID

PositionName

etc...

Day:

PlayerID

PositionID

Date

etc...

This is the basic structure, then you can add whatever additional fields you want to collect other information. All your reports and summarizations will then run from the Day DB, and you can summarize by day, month, year or whatever.