Nested relationships in a portal - help

[backsmith]

I am migrating an application from FM5.

Ive got tables of patients, doctors, and appointments.

I want to show diarys for several docs on the same page. I have used the date and DocID to make a unique whole day keyID and use this to populate 7 portals on screen.

This far works fine.

I can get the patient IDs into the portal but I want to display the names.

In FM 5 I just had on relationship between appointment and patients to populat the patient name in the portal.

This is not possibel in FM10.

I am using a calculated filed to lookup the surname and inital from the patient file.

Any one done this?

Any help appreciated.

Thanks John

[Fitch]

Back in FileMaker 5, you would have to "pipeline" the patient and doctor names into Appointments in order to see them in a portal of Appointments. Nowadays, you don't necessarily need any calculated fields or lookups.

Assuming your appointments table contains:

Appt Date

Patient ID

Doctor ID

All you need is a Table Occurrence (TO) of Patients and a TO of Doctors, and relate each of those to the Appointments table by their respective key fields (ID). You can then show the related data even though it is more than one table away from the layout's base table.

[backsmith]

Thanks for your help.

Ive got the Table Occurrances it looks loke this.

Doc1 is the Patients file link field (DOC&DATE)

Patient::Doc1 = APPOINTMENT (TO1):APPOINTMENT CODE

ETC through 7 repeats for 7 docs.

This populates the portal.

Appoinments contains PatientID and I want to use this to look up the patient name.

I have tried seven seperat TO's linked to the TO's of appointment and also a seperate Appontments to Patient relationship.

The first portal shows the patients names fine but the rest show unexpected results.

All these tables are in the same file. With FM5 they were seperate files. The imported version (seperate files) works in FM10 but its slow and not eligant.

Am I missing something obvious?

Reading this back I can see that I am using PAtients to open portals on Appointments that then looks back to a seperat TO of Patients. Is that the problem? FM 5 didn't seem to mind that sort of thing.

Thanks for your help.

John

[backsmith]

AH HA!

Got it. Set up the related TO's but needed an extra window refresh with cache flush to make all the portals display properly.

Cheers

John