Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Squeduling System

Posted on 2002-05-09
7
Medium Priority
?
188 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
[X]
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
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

610 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