Relationships and queries

[Nona]

I want to set up a database that will track medical appointments -- 3 Tables
- Patient Names, Health Care Professional Names, and Appointment
Dates/Times.

I would like for the data entry form to have 2 list boxes - one for
selecting the patient's name and the other for selecting the name of the
health care professional. Other fields in the Data Entry form would be for
input of the date and times of the apt.

I am having problems with knowing how to set up the primary keys and the
relationships between the tables. Here's my thought process:

The Patient Names table will have a unique ID with a one to many
relationship to the same ID in the appointment table.

The name of the health professional in the Health Care Pro table would have
a one to many relationship with the name of the health prof entered in the
apts table.

The primary key in the Patient Names table should be the Unique ID. But what
should be the primary key in the other two tables?

Is this the best way to set up this database?

Thanks for your help!

 

[Ronx]

You will get better answers in a forum or newsgroup dealing with your
database - FrontPage is a website building application.

I agree with Patients Names set up
Set up Health professional the same way - Unique id for each
professional, but do not use their names as the ID, there may be 2 named
John Smith.

The appointments table should have its own primary key for each
appointment, with foreign keys from the Patients names and Professionals
tables.

I suspect a calendar will be required to show available/used appointment
times for each professional.

As I said - best to ask in the database forum for good advice.