I want some fields on a layout to be prepopulated with the most probable value. If the value is not the desired one I can select another one from a dropdown. The most probable value is is updated periodically in a Value List (it's the current ingredient batch number in use) . So I have it is set up with Auto-enter Calculation as follows:
Let ( [
listvalues = ValueListItems ( filename ; "LotMPutilise" );
lot=GetValue ( listvalues ; 1 )
and it works allright. The LotMPutilise is a manually set Value List.
I have another value list that is made through self-joining relationship and there my autoenter doesn't work.
All advice is welcome.