Viewing Records In A Form

[suzzieo]

I have a form that has 2 subforms in it. I have 400 records in the database.

Example - Main form includes patient name and address
One subform includes name of training session attended and date.

The patient can attend more than one session, so my relationship is one (patient) to many (sessions attended).

I have one patient who has attended 5 sessions.

My problem is that when I'm paging through the records on the main form, when I come to the patient who's attended 5 training sessions, the record number at the bottom changes, however, it continues to display the same patient name 5 times (I assume because they've got 5 training sessions) instead of moving to the next patient.

What have I done wrong? Help!!

Thanks.

 

[AncientOne]

Do you mean that the main form displays the same patient and all his/her appointments five times? Or that the subform records don't change?

 

[AncientOne]

Just to confirm:

A form/subform is used to link data from two tables which have a one-to many relationship. Therefore, your data must come from a Patient table with PatientNumber (or other unique identifier) as a primary key, and from an Appointments table which has PatientNumber as a foreign key. In your Relationships window those two fields must be linked in a one-to-many relationship.

Is this how you have your tables set up?