F
Fysh1
I sent a request yesterday for someone to take a look at
my design, but no takers. Can someone explain to me what
I am doing wrong with this. I have several clinics, with
each having different and same appointment types, with
each having different staff, and each with different exam
rooms. I am trying to create a db so all clinics can
share the same program. I have the ClinicID with a one-to-
many realtionship with all the tables, This is what I came
up with, but doesn't seem right. Also, what do I do if
the patient is a walk-in and is here for a specific
reason. How do I list it in the Visits table appointment
type as a walk-in and a reason? This person would have 2
types for the same visit. So on the form it won't be an
Option Group, it would be multiple check boxes instead.
Hopefully this makes sense.
tblVisits
CustomerID
TypeID
StaffID
RoomID
ClinicID
Date
Etc.
tblCustomer
CustomerID
FName
LName
Etc.
tblClinic
ClinicID
Clinic
tblAppointmentType
TypeID
Type
ClinicID
tblRoom
RoomID
Room
ClinicID
tblStaff
StaffID
ClinicID
StaffLName
StaffFName
Etc.
Thanks for your time.
my design, but no takers. Can someone explain to me what
I am doing wrong with this. I have several clinics, with
each having different and same appointment types, with
each having different staff, and each with different exam
rooms. I am trying to create a db so all clinics can
share the same program. I have the ClinicID with a one-to-
many realtionship with all the tables, This is what I came
up with, but doesn't seem right. Also, what do I do if
the patient is a walk-in and is here for a specific
reason. How do I list it in the Visits table appointment
type as a walk-in and a reason? This person would have 2
types for the same visit. So on the form it won't be an
Option Group, it would be multiple check boxes instead.
Hopefully this makes sense.
tblVisits
CustomerID
TypeID
StaffID
RoomID
ClinicID
Date
Etc.
tblCustomer
CustomerID
FName
LName
Etc.
tblClinic
ClinicID
Clinic
tblAppointmentType
TypeID
Type
ClinicID
tblRoom
RoomID
Room
ClinicID
tblStaff
StaffID
ClinicID
StaffLName
StaffFName
Etc.
Thanks for your time.