Joester20
asked on
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
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
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.
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.
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.
Also, you will find the WeekDay() function quite helpful.
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
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
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
Patients
PatientID
PatientName etc
Procedures
ProcedureID
Price etc
PatProcedures
PatientID
ProcedureID
Treatments
TreatmentID
ProcedureID
TreatmentName
TreatmentSequenceNumber etc
PatTreatments
PatientID
TreatmentID
TreatmentDate
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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