Show only NOT used products

[Raybaudi]

Hi all friends

I need to have a value list filtered so that it shows products NOT used into an invoice.

It can be easily made with a plugin like EventScript ( see attached file ), but w/o it ?

Invoice_wo_repeating_line_items.zip

[comment]

Like this?

Invoice_wo_repeating_line_items.fp7.zip

[Raybaudi]

Thank you, comment.

Yes, like that !

I didn't know the extreme power of that script step:

Refresh Window [Flush cached join results]

It's correct to say that that step forces the recalculation of unstored ( because related ) calcs ?

And, do you think that the same effect can be obtained without a script ?

[comment]

I don't know of a way to do this without a script. Without a script, user could move to a new line item without committing the previous one. An uncommitted line item will obviously NOT be included in the list.

This is IN ADDITION to the usual problem of one relationship depending on the results of another. Filemaker does not always see the connection beteen the two, and continues to rely on the cache. That's what the step really does: it forces recalculation of results obtained from a relationship.

[Raybaudi]

Clear as always, thank you again

[fabriceN]

Hi Daniele,

it seems to be a job for FilterValuesByTest().

FilterValuesByTest ( ¶ & List ( invoiceItemsIDs ) & ¶ ; "value" ; "PatternCount ( text ; ¶ & value & ¶ )" ; 0 )

Edited April 15, 2007 by Guest