setting up relationship
I'm fairly fluent in Filemaker; but, somewhat rusty. I'm using version 8.5 with Windows XP.
I've created my layout and everything looks fine.
But, what I'm having difficulties with is coding the incoming data to do what I need it to do.
Basically I'm uploading surveys. The survey responses are answered with numbers (1, 2, 3, 4, or 5). Each number represents Strongly Agree, Agree, Neutral...etc.
But, instead of the numbers showing up in Filemaker I want to build a relationship so that it knows when it sees a number "1" to count it as a "Strongly Agree".
And ultimately I want to be able to find out the percentages of each answered question (25% Strongly Agree, 15% Agree and so on).