Solved

Squeduling System

Posted on 2002-05-09
7
181 Views
Last Modified: 2010-05-02
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
Comment
Question by:Joester20
7 Comments
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 7000431
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
 
LVL 45

Expert Comment

by:aikimark
ID: 7000506
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
 
LVL 45

Expert Comment

by:aikimark
ID: 7000508
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 3

Expert Comment

by:n_narayanan
ID: 7000613
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
 
LVL 18

Expert Comment

by:mdougan
ID: 7001416
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
 
LVL 49

Expert Comment

by:DanRollins
ID: 7722528
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
 

Accepted Solution

by:
SpideyMod earned 0 total points
ID: 7780577
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now