Im an absolute newbie with filemaker and am using this program to contruct a mediacal database to help my Phd project. I allready posted this question in another of the forums, but i think it should be here.

Im using Filemaker to input patient data, and i want to use it later in SPSS for statistics.

My biggest problem is the following:

I have a list of questions that can be answered by "yes" or "no"

For instance: "Hypertension"(this is a field) and then radiobuttons with yes and no (using a value list with yes and no in it)

In my report i would like to see for yes a "1" and for no a "2", but still dont know how i should do this. (all these questions use the same valuelist)

The same problem arises for the question smoking? (a field again) with the value list "0", "1-5", "6-10", "11-20", and ">20" I also would like to see this in my report as nr's from 1 to 5

I hope this question isnt to vague, and i would be very gratefull if someone can give me a helping hand

HJALMAR HANSEN

[email protected]

[email protected]

This was asked and answered in the Define Fields forum.