[FX.php List] RE: [OT] FM 9 Bug?

[Tom Sepper]

As a follow-up, manually entering a zero into the table 2 boolean field fixes the glitch. Definitely looks like FM 9 won't accept null values in relationships.


Tom Sepper
Director of Information Technology
Director's Choice Tour & Travel

P 806.762.6354
F 806.763.7637

tsepper at directorschoice.travel
www.directorschoicetourandtravel.com



-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org on behalf of Tom Sepper
Sent: Fri 7/13/2007 3:50 PM
To: FX.php Discussion List
Subject: [OT] FM 9 Bug?
 
I came across an odd bug in FileMaker 9 and was wondering if anyone could verify.

Two tables. Table one has a calc field that simply has a numeral 1. Table two has a boolean number field; 1 indicates yes, null indicates no.  Relationship is if the calc 1 field does not equal the boolean field.  

What I've discovered is that FileMaker now does not accept the null value in the relationship. No longer can you see from table 2 back to table 1.

Table 1 is the many; table 2 is the one.

Can anyone concur? 

If so, this is a huge block in adapting FM 9 for my database solution.


Tom Sepper
Director of Information Technology
Director's Choice Tour & Travel

P 806.762.6354
F 806.763.7637

tsepper at directorschoice.travel
www.directorschoicetourandtravel.com

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3223 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20070713/18a41d9a/attachment-0001.bin