Nicolas Dupont

You're awesome... That worked... Thanks a lot for your quick reply

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.

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