drpencilcase

I'm looking for a personal copy of FM9 for myself. I don't want FM10 because I really need the ability to export to dbf format. I've searched online but only found CDs with no licenses. Does anyone know where I can get a copy?

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).

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.