FM 12 relationships...

[ron G]

I am using FM 12 Adv on OSX and Windows

First, I KNOW there is something I don't get about TOC. Perhaps you can elighten me?

Below is my project. It is a medical records database with these tables:

Patients (PKPatientID, LastName, FirstName etc...

Doctors, (PKDoctorID, LastName, FirstName etc...

Procedures (FKPatieID, FKDoctorID, Name, etc....

RX (FKPatientID, FKDoctorID, Name, Date etc...

Lab Tests (FKDoctor ID, FKPatientID, Test Name ...

Vital Statistics (FKPatientID, Patient Systalic , Diastalic, Pulse etc by date)

On the PATIENT Layout, (see below) I have a tab object. Each tab has a portal that holds Procedures, RX, Lab Tests, etc...

The problem for me is that I don't get how I can have a layout based on Patients AND have Procedures Portal work? Filemaker

DEMANDS that I create another instance of PROCEDURES so I can relate Patients to Procedures2. But in so doing, my Procedures portal is blank? I tried basing the Procedures portal on Procedure 2 (and it's fields) but that did not work.

Ideas are appreciated.... Thank you.

[ron G]

I think I got it.

I needed to replicate the Doctor TOC for each procedure and then reference the Doctor::PKDoctorID in the FKDoctorID in the dropdown in each 'Lab Test', 'Procedures' and 'RX' TOC's. It seems so clear now.... I hope this helps someone else.

[bruceR]

You might want to consider renaming the occurrences, respectively, Procedure_Doctors and Lab_Test_Doctors.