Hi, In the OnOpenForm on the contact card i filter my Contact table with a flow filter. Now when i open my contact card it takes for ever to open the card.I tried to use the setcurrentkey before i set the filter but navision doesn’t allow to use a flowfilter as a key. Is there another solution to this problem [?] Thanks, wendy
Hi Wendy! As you can’t set a FlowField as a Key, you should make sure, that there are “optimized” keys in that table, which is the “base” of the FlowField! e.g. if your FlowField creates a Sum on an amount in Table XY, which is “influenced” (FlowFilter) by a Date, Table XY should contain a Key, where the Date is included (SumIndex: Amount) … Regards, Jörg
Wendy, Joerg has got in before me - problem with being in a Navision workshop all day! [:D] All I would add is, set the best key where ‘Date’ is included. ie: The key where ‘Date’ is closest to the beginning of the key! Hope this helps [:D]