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

[Dale Bengston]

Hmm, doesn't null create an invalid relationship? I use 0 and 1 for  
boolean keys.

Dale


On Jul 13, 2007, at 3:50 PM, Tom Sepper wrote:

> 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
> <winmail.dat>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list