Hi guys,

I am trying to create a database for a clinic, and am severely stuck on how to input appointment dates for individual patients.
I have been using the 'student' database from office.com as a template for how to save the dates (given that appointments and attendance are exactly the same!), however, even after following what has been set up in the 'student' template database, I can't seem to replicate it.

Every time I add multiple visit dates for a specific patient, these exact dates show up for every other patient in the database. I need to be able to add different dates for all the different patients.

I am completly new to Access, so any simple help would be much appreciated!

Thankyou in advance for any comments!

First, welcome to UA!

The relationship of your data is the starting point.

You need to establish the relationship before going any farther.

If data was in a one-to-one relationship (one salesman, one product) you could usually just use one table and one form.

Your data seems to be one-to-many (one doctor, many patients) or in your case one patient, many dates.

You would need two tables in a one to many relationship. The primary key in the one side would connect to the foreign key in the many table.

That would establish that relationship.

Then you would use a mainform for the one side and a subform for the many side.

Try that and post back.

The form wizard should set that up for you.

Katrine,

Greetings and Welcome to UtterAccess

Here's a link that will (hopefully) help clarify things for you - Library of Database Models

You can use Ctrl+F (Find) to search for Hospital and/or Patient models.

Post back when you have more questions.


AvgJoe

You might like to have a look at a demo I did some time ago, its hosted at our Glen Krugers' site HERE look for JWoodwardAppointments. Sorry it does not look good in Access 2007 it was written for A2003

HTH Z

katrine_r,



If you click on the "Search" link near the upper right corner of the site, you can type "appointment" and then select the "Code Archive" forum. That should turn up five or six differently-flavored demos that you can download and test out to see if it's close to what you need.

Hope this helps,

Dennis

Hi Katrine,

Dennis provided you with the info for some demo's in the archives that should get you started.

You may want to take a look at this link related to medical information within database systems in order to meet HIPPA requirements:

http://www DOT compliancepointis.com/sub_compliance_hipaa.asp?gclid=CJKp8JuilLACFUvDtgodkFz4qQ

An Access backend database does not meet those requirements, however you can use MS Server, etc. and still use the Access front-end with your forms, reports, etc.

Good luck with your project!!

Aqua,

Thanks. It's important to remember the Health Insurance Portability and Accountability Act whenever dealing with potentially sensitive medical data.

Dennis

Hi

Can you upload a zipped copy of your Db so we can take a look

Hi Katrine,

Maybe this Outlook Style Calendar Demo will do what you want.

Peter Hibbs.