EasyCFM.COM ColdFusion Forums / MySQL Related Issues / Database setup help

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Database setup help

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

MIGhunter
05-03-2008 @ 1:17 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 570
Joined: Apr 2006

I'm writing a program for myself to use at my job.  The 1st part of the program is a list of all the people in the establishment and then their pertinent information.  It uses a search form to pull them up.  Then I decided to expand it.  Each of these people are on call for their particular job.  I am having an issue figuring out how to make a database with all the people, their job and the days of the month.  So, basically it would be:
                   day1 | day2 | day3 | day4 | day5
Cardiology:  MD1  | MD2  | MD3  | MD4  | MD5
Internal:      MD1  | MD2  | MD3  | MD4  | MD5


I need it to be able to do the 12 months of the year and also link to the current MDinfo table that I have.  That way it would link to their information.

GrowlyBear
05-03-2008 @ 10:02 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 1314
Joined: May 2004

Each person same day/everyweek/everymonth ?

Forget the layout/output until you have all the fields I need.

So what "pertinent" information you already got?

~~~~~~~~~~~~~~~~~~~
CF PaperClip
http://www.cfpaperclip.com
CF & OOP in baby steps.

MIGhunter
05-03-2008 @ 10:21 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 570
Joined: Apr 2006

Basically it's a calendar for an "on call" list.  The info I have is the Staff members: name, office number, cell number, home number, fax number, etc.

What I want to do is take the archaic paper schedules for each staff and put it into the computer.  So, it won't be the same person every day.  I want to enter in the entire month into the database but when I output it, I want it to show the day only.  The end form looks like

Anesthesia:                        Opthalmology:
Cardiology:                         Oral Surgery:
Coroner:                            Orthopedics:
etc....

Each day it's a different staff member for each section.


Website Designed and Developed by Pablo Varando.