AnsweredAssumed Answered

Relationship breaking with calculation

Question asked by disabled_rosalie on Oct 23, 2015
Latest reply on Oct 25, 2015 by user19752

Hello All,


I have a problem regarding my relationship;


In my Menu table I have the following fields;


Field NameTypeOption
constantCalculationIndexed, = 1
constant todayCalculationUnstored, = Get(Current Date)
Materials Expiring TodayCalculation

Let (

[ AlertCount = Count ( Materials Expiring Today::MATERIALS ID MATCH FIELD ) ] ;



AlertCount = 0;TextColor ("0" & " Material Expiring Today!";RGB(120;120;120));

AlertCount = 1;TextColor ( AlertCount   &  " Material ¶ Expiring Today! ";RGB(0;136;0));

AlertCount > 1;TextColor ( AlertCount   &  " Materials ¶Expiring Today! ";RGB(220;0;0))



Global NumberNumber


Warehouse Table Field Second Table Field


Field NameTypeOption
constantCalculationIndexed, = 1
Material Expiry DateDateIndexed
Material Quantity Balance
Material Quantity UsedNumberIndexed
Material Quantity ReceivedNumberIndexed


In my Relationship for my TOC for my Portal


MenuMaterial Expiring Today
constant= constant
Constant Today= Material Expiry Date
Global Number< Material Quantity Balance


My Problem is when I change my Material Quantity Balance into Calculation ( Material Quantity Balance, = Material Quantity Received - Material Quantity Used) because I don't want to enter every time my Material Expiry Date Alert will give me ( ?Materials Expiring Today). when I leave as it is (field type is Number) it will show me the count of materials.


Any help how to avoid this is highly appreciated.


Thank you