Jump to content

Need Help w/ Personell-Scheduling DB


ronkmd
 Share

This topic is 6506 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6506 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.