Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

Squeduling System

Hi

im really stumped here

im trying to create a doctors office scheduling system

a patient comes in and was scheduled he/she paid $5000.00
but sitll needs to come in for 6 more treatments that will be scheduled later

how should i go about setting this up

i have a table with all the procedures and prices
and a table called tblPatProcedures
which has the date, time eventid, clientid etc. for this one event
but how can i schedule it for all five events under the same procedure

thanx
0
Joester20
Asked:
Joester20
1 Solution
 
Richie_SimonettiIT OperationsCommented:
One patient could have many schedules so schedules must be in a separate table some like that:
id 'could be autonumber field
clientid
date
time
invoice
ScheduleNumber
.....
.....
You need to create tables taking in mind entities. I mean, each table must represents an entity.
Hope it helps
0
 
aikimarkCommented:
You will also need a scheduling interface that allows the user to determine the frequency and occurance of the future visits.  Their choices will determine what dates are INSERTed into the appointments table (many-to-one relationship with the Patients table).
Examples:
* every other Thursday
* the second Friday of every month
* the last day of the every month
* once a week, starting next Monday

It will also help if you create a holiday table and allow your administrator to populate the table to exclude dates.

You might also benefit from adding an easy-to-use calendar control to your form for picking dates.
0
 
aikimarkCommented:
Just a reminder...Dates and Times are represented by Double datatypes (integer part ~ date; fractional part ~ time-of-day).  It is fairly easy to add values to a date variable with both simple arithmetic and the DateAdd() function.

Also, you will find the WeekDay() function quite helpful.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
n_narayananCommented:
In tblPatProcedures
ensure that eventid is not a part of primary key. It is obviously a Foreign Key to the procedures and prices table.

Now get the another six schedule dates and times

then issue the insert statement.

Can explain your problem with little more detail

Narayanan
0
 
mdouganCommented:
Well, you've identified one relationship, you just need to keep going:

Patients
PatientID
PatientName etc

Procedures
ProcedureID
Price etc

PatProcedures
PatientID
ProcedureID

Treatments
TreatmentID
ProcedureID
TreatmentName
TreatmentSequenceNumber etc

PatTreatments
PatientID
TreatmentID
TreatmentDate
0
 
DanRollinsCommented:
Hi Joester20,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Save as PAQ -- No Refund.

Joester20, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
0
 
SpideyModCommented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now