Apt today

ICTkirsten · Feb 1, 2015

Hello,

This is really confusing but..

I am creating a dentist booking system and i need some way to display appointments today for a certain dentist and then from their to click the customer and view their teeth details that the dentist will use to update...

i know it involves a query but im beyond lost on a way to head around this..

Any help would be fab!

thank you

jdraw · Feb 1, 2015

Please post a copy of your tables and relationships.

Query for sure, but readers have to know what tables and fields are available.

ICTkirsten · Feb 1, 2015

Thanks for the swift reply..

I have attached my relationships and tables.

Ps. sorry its really messy i had to rename things for confidential reasons

jdraw · Feb 1, 2015

Do you have multiple dentists?
Does the appointment indicate the nature of the work to be done?

How does optician fit into any of this??

Can you describe in plain English - a typical appointment/booking? Dentist involved? Work to be done? Any special notes?

You know something like:

Cody Akbear is having a terribly time with a broken tooth......bla,bla...
Just trying to see the process in general.

ICTkirsten · Feb 1, 2015

Yes i have multiple dentists
No the appointment doesnt its not needed in my case..

sorry i miswrote that it was meant to say dentist.

The process goes: somebody calls in and books an appointment i make their appointment via my create appointment form.

when their day comes the dentist has a report viewing which customers they have and at what time and can click on the customer to see their teeth history so they know what they are working with..

My problem is i am trying
to create a form that shows the details of 1 customer only.The dentist can then use the navigation buttons to go through the appointments for that day (so a query where the dentist enters their name / login to get to the form)

When the dentist has the details of the customer up, i need a sub-form that shows the past teeth details of the current customer with space at the end where the new teeth details can be added (the sub-form will be a multiple item form)....

^ i hope this is clearer ^^ thank you so much for your help

jdraw · Feb 1, 2015

Just a few more questions while I'm reading your latest post.

Customer 99 can have 1 or more History records. Seems to me those records are linked to Customer, and each record would identify the dentist(s) involved. That is could a Customer have different dentists for different appointments? And could more than 1 dentist be involved on any given appointment?

What exactly is in your Time table? I'm trying to visualize data in table.
How do you know how long (duration) an appointment is for?

Seems you need a CustomerHistory table. Your form would have CustomerInfo (name address,etc, XRays..) and the related subform would have history records (procedures done)

Do you have a table for Dentists? Seems an appointment would be a relation of:

CustomerID
DentistId
TimeSlot (Time/Date and perhaps Room)

Here is a free data model that may give you some ideas.

ICTkirsten · Feb 1, 2015

That is could a Customer have different dentists for different appointments? Yes

And could more than 1 dentist be involved on any given appointment? No

What exactly is in your Time table? its just the times starting from 9:00- 5pm ( excluding 12-1 which is lunch) each appointment is 20 minuites ^^

And oh i see yes your right!i didnt thnk of creating that type of table! thank you

jdraw · Feb 2, 2015

Note that the model I suggested is a generic model and doesn't necessarily match your requirements. However, there may be parts of the model that are applicable to your needs -- use as much or as little as you need.

Here's a link to a free video dealing with forms and subforms. There are others --just search youtube.

I have attached a quick and dirty demo showing form/subform based on some sample tables and data I created.

ICTkirsten · Feb 2, 2015

This is absolutely terrific!

You have been great help

Thank you so much

ICTkirsten · Feb 2, 2015

Just a quick question..

The patientID and patientidfk... i dont really understand this.. arent the two the same? or should be the same? as they both identify the patient. what do they do?

i dont understand what you mean by : " i then set the link field form to the subform"

sorry for my confusion. ><

Thank you

jdraw · Feb 2, 2015

PatientID is the unique identifier for the Patient
PatientIDFK is the same data value. It is the field that relates the Patient and the Visits.
The records for PatientID 1, have PatientIDFK 1 in the PatientVisits table.

Did you watch the form/subform video?
He used the wizard to add a subform to his form, and then he selected "StudentId" to be the the "linking" field. You need a common field between the Form and subForm, to keep the proper records "linked" for the display on the form.

Apt today

ICTkirsten

Registered User.

jdraw

Super Moderator

ICTkirsten

Registered User.

Attachments

jdraw

Super Moderator

ICTkirsten

Registered User.

jdraw

Super Moderator

ICTkirsten

Registered User.

jdraw

Super Moderator

Attachments

ICTkirsten

Registered User.

ICTkirsten

Registered User.

jdraw

Super Moderator

Similar threads

Users who are viewing this thread