AnsweredAssumed Answered

related records

Question asked by LarsGrieten on Jan 15, 2013
Latest reply on Jan 16, 2013 by LarsGrieten

Summary

related records

Product

FileMaker Pro

Version

fmp 12 advanced

Operating system version

win XP

Description of the issue

Hi, Filemaker noob over here... I am working in the medical field and I'm building a database for scientific studies and I have a question regarding scripting.

Currently I have a patient in patients table with a unique ID.

Patients ==> examinations ==> ECG, SPIRO, BLOOD, ....

Every patient has a unique ID, and upon visit the patient has an examination. So creating a new record in examination will generate a unique KEY. To couple this ID to the examinations the script currently copies the Unique patient Key, goes to the ID field in examinations and the script pastes this in the according field.

The same for the examinations. upon each visit the patient has several examinations. so for each test he takes (ECG, Spiro, blood, etc...) the unique number of the examination is copied and pasted in the table of examinations to relate this back to the same patient.

It works fine untill now!
However this does not feel koosjer, Is there a more professional way to populate this field to create these relations?

Thanks a lot in advance!

problem.png

Outcomes