Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Squeduling System

Posted on 2002-05-09
7
183 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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

840 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