You can download a FileMaker 6 file and a FileMaker 9 file that
demonstrates this from http://www.asktami.com/site.lasso?
fuseaction=client.listfiles&link=demo
In FileMaker 6 Yes, Y, True and T all translated to 1 and No, N,
False and F all translated to 0.
So, you could do stuff like have a serial number field "testID"
and have a text field "testYDisplay" with a the word "Yes" in it
and have another field "testCalc Txt" - a calc field with the result
= text - with this calc:
If(Left(testYDisplay, 1), testID, "")
and the result would be thant the testID value would show in the
testCalc Txt field.
This works in FileMaker 6. It does NOT work in FileMaker 9.
Is there something I'm missing? Is there a way to get this to work
in Filemaker 9? Or do I have to find all the calcs like this and
make them:
If(Left(testYDisplay, 1) = "Yes", testID, "")
Thanks in advance. (I'm converting a FMP 6 solution to FMP 9 and
this is a problem...)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"It's better to burn out than to fade away."
Tami Williams
Creative Computing
Improve, manage and unify data with custom database and web
applications.
FileMaker and Lasso specialist.
Tel: 770.457.3221
Fax: 770.454.7419
E-Mail: [EMAIL PROTECTED]
Web: http://www.asktami.com
FileMaker Solutions Alliance Associate | Lasso Professional Alliance
Member
