Tip: Watch your calculated field types!

[xochi]

Several times, I've created a relationship only to have it fail to operate properly. I double check all the Table Occurrence and Field names, and everything seems to be in order. Where I've gone wrong several time is that one of the fields is a Calculation that returns Text, and by accident I set the "Return type" to "Number" instead of "Text". FileMaker won't warn you that your text field is set to number, and your relationships will just fail silently.

Hope this reminder can save someone some hassle!

[xochi]

Several times, I've created a relationship only to have it fail to operate properly. I double check all the Table Occurrence and Field names, and everything seems to be in order. Where I've gone wrong several time is that one of the fields is a Calculation that returns Text, and by accident I set the "Return type" to "Number" instead of "Text". FileMaker won't warn you that your text field is set to number, and your relationships will just fail silently.

Hope this reminder can save someone some hassle!

[xochi]

Several times, I've created a relationship only to have it fail to operate properly. I double check all the Table Occurrence and Field names, and everything seems to be in order. Where I've gone wrong several time is that one of the fields is a Calculation that returns Text, and by accident I set the "Return type" to "Number" instead of "Text". FileMaker won't warn you that your text field is set to number, and your relationships will just fail silently.

Hope this reminder can save someone some hassle!

[BrentHedden]

Ahh yes - this is also true when you try to use mathmatics on text, and other various things.

It can be very frustrating indeed to try to track down such things.

Thanks for the post.

[BrentHedden]

Ahh yes - this is also true when you try to use mathmatics on text, and other various things.

It can be very frustrating indeed to try to track down such things.

Thanks for the post.

[BrentHedden]

Ahh yes - this is also true when you try to use mathmatics on text, and other various things.

It can be very frustrating indeed to try to track down such things.

Thanks for the post.