I'm a medical student doing a database for a medical research project and I've decided to try FM9 (since it's avaiable at my school).

The thing is one patient may have more than one exam (echocardiogram). So I've created a separated table and used a portal to show all exams of each patient. The problem is that when I export, it always export (i have to export to SPSS for the analysis) the first exam created for that patient.

So I tought that one way to counter this would be to recreate the fields in the main table (as calculation fields) in such way that for each patient I could select which exam would be exported. So I've created a field(examselect) on which I would select the echo_id (the exam's unique id).

Here's what I want to do:

On the main(patient) table:

X'= value from field X from table echo from record (echoid=examselect).

I've tried to find which commands to use but i failed. Can someone please help me with this syntax or suggest another way to achieve my goals.

thanks.

Oh, I think I would have the new field 'selectExport' in the Child record [exam.] With a set field script, selecting it would enter a 1 [and deselect any other 1's for that patient.]

Then you can do a find in the Exam table for "1", before exporting.

Does this make sense?

*susan*

You need to define another relationship between patients and (a second occurrence of) exams, matching examselect to echo_id. Then export from the patients table, using both local and related fields (no need for calculation fields to replicate the related values).

thanks a lot. Both suggestions worked, and I've decided to go with the second one since it was easier to work with (allowing me to export multiple exams per patient, eg. before and after treatment).