Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Squeduling System

Posted on 2002-05-09
7
Medium Priority
?
189 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 46

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 46

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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

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

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

581 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