Hi,

I'm very new to filemaker and I'm trying to develop a medical db.

I have a table containing all of the consultations. each consultation can 1 to 4 different types and each type will have one or more diagnostic.

I'd like to display a portal with all the diagnostics but can't seem to do it.

I have a consultations table (consultations) related to 4 tables for each type (epaule, hanche, pied, genoux) and each type is related to the same diagnostic table (rel_pat_diagnotic) that appears as 4 dif table occurrences (rel_pat_diag_epaule, rel_pat_diag_hanche, rela_pat_diag_pied, rel_pat_diag_genoux).

My problem is that I can't seem to show all the records from the diagnostic table for a specific patient as it appears as 4 separate occurrences.

I'm really stuck and would appreciate some help.

Nicolas

What is the reason for splitting the types into 4 tables?

Just because I'm actually trying to convert a DB that was created in access and that's the way it's stored.

Plus there's a shitload of field in those 4 tables and it's easier to navigate.

The question is whether there is any REAL reason to split the tables. Perhaps there is - but the two you have mentioned are not. It seems that the Diagnostic table is common to all types, so why not have:

Patients -< Consultations -< Diagnostics

This is assuming that a single consultation can have more than one diagnostics; if not, then this probably could be simplified further.

You're awesome... That worked...

Thanks a lot for your quick reply