It sounds like learning more about filemaker in books or with online tutorials could help you a lot. I'll give you some basic outlines here, but such study will better enable you to apply these techniques.
"I already designed a 5 scale vale (No Symptoms, None, Mild, Moderate, Total Disability) as a "radio button set" on many "fields",
How can I transfer these fields to number value and then calculate for its "Sum"?
For example, "No Symptom" = "0" and "Total Disability"= "5", then database will sum all the field value and show the total output "
Seems like "Total Disability" would be 4 or "no symptoms" would be 1 from your example. Do you want a count or a total? You could use a summary field to count the number of records. In a summary report sorted by the value in the radio button field such a "count of" type summary field would count the number of records where each symptom was selected.
If you want a number equivalent, you can define a calculation field with a case statement that returns a different number for each option selected:
Case ( ScaleField = "No Symptoms" ; 0 ; ScaleField = "None" ; 1 ; ScaleField = "Mild" ; 2 ; ScaleField = "Moderate" ; 3 ; Scale Field = Total Disability" ; 4 )
For your last question, you can define a separate table with a different turning radius and Product in each record in this table. Relate it to your first table by the turning radius field and you can place the product fields on your layout to display a matching product. If there could be more than one such matching product, you can use a portal to display a scrolling list of all such matching records.
Dear Phil Caulkins
Thanks for your help. The first answer is really helpful ^^
For the last question, could you explain more detail about this part?
I don't understand the meaning of "relate " in your answer (Relate it to your first table by the turning radius field and you can place the product fields on your layout to display a matching product).
Besides, how to make a relation between two different field in different Table with different field content?
Is it the same function of "Relationships"?
P.S.. Now I am reading "FileMaker Pro 10: The Missing Manual " as my reference
Thanks a lot
I'm actually suggesting that you relate the tables by having the same data in a field in both tables.
Your table might look like this:
Turning Radius | Product
Small (Below 20") | WheelChair Product A
Medium (20" - 25") | WheelChair Product B
Large (Above 25)" | WheelChair Product C
If you use a portal, you can have multiple records with the same Turning radius that are displayed.
In your relationship graph at Manage | Database | Relationships, you'd have:
YourTable::TurningRadius = WheelChairs::TurningRadius
With this relationship, you can place the Product field from the above example directly on your layout if you want to show just one product or you can place it in a portal to show a whole group of wheel chair products with matching turning radii.