Table relationship please help

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top