May 30, 2011; 14:34
Andreas Carlsson
Relation based on global field doesn't work in search?
Hello guys,
I need some help here...
SITUATION:
A client have all invoices and payments registered with a Filemaker solution. Together with this they also have an "accounts ledger" (I'm not sure of the correct english word for this, in swedish it's called "reskontra"), to see how much their customers owe them.
CONCERN:
I would like to create this ledger based on a given date. Ie to be able to see how it looked the 1st of january for example.
PROBLEM:
All payments are related to their invoices. To solve the concern I created a global field called "xDate", and matched the relation with Invoice ID and xDate >= Payment date.
It works as it should when I *look* at a given Invoice, but as soon as I search for "cClaim > 0" it doesn't work (cClaim is a Calculation that sums all payments). No matter what I set xDate on I always get the same invoices found. No matter if I flush the cache and other things, I always get the same invoices found.
It appears that the relation doesn't work in Find mode.
I have created an ugly workaround for this (giving all payments an "active/inactive status") but that takes time, and is not as good as the Global field solution, if it had worked. :(
Any ideas or better solutions?
Thanks,
/andreas
FM11 on Mac, FM Server 11 on Mac.
#############################################################
This message is sent to you because you are subscribed to
the mailing list <fmpro@lists.lassosoft.com>.
To unsubscribe, E-mail to: <fmpro-off@lists.lassosoft.com>
To switch to the DIGEST mode, E-mail to <fmpro-digest@lists.lassosoft.com>
To switch to the INDEX mode, E-mail to <fmpro-index@lists.lassosoft.com>
Send administrative queries to <fmpro-request@lists.lassosoft.com>
May 30, 2011; 14:20
Steve Cassidy
Re: Relation based on global field doesn't work in search?
May 31, 2011; 10:18
Andreas Carlsson
Re: Relation based on global field doesn't work in search?
May 31, 2011; 10:52
Steve Cassidy
Re: Relation based on global field doesn't work in search?