<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi,</p>
<p>In one of my form setups, I would like to filter one relation reference widget combo box with a filter expression based on the selected entry of another relation reference value.</p>
<p>A static filter like:</p>
<p><span style="font-family: courier new, courier, monospace;">szenario_art = 'Brand'</span></p>
<p>works as expected and it returns the filtered values - but as soon as I try to base it on the value of another relation reference widget, it fails ...</p>
<p>I tried</p>
<p><span style="font-family: courier new, courier, monospace;">szenario_art = current_value('szenario_art')</span></p>
<p>but no records get selected.</p>
<p><br /></p>
<p>Questions:</p>
<ul>
<li>Does the current_value() return the "internal value" or the "human readable" value?</li>
<li>Do I have to eval() something in the filter expression?</li>
<li>Is there a way to test "current_value" somehow? I tried to write the changed value into another text widget (with default values on update), but it will always return "NULL". In the expression editor, I also always get "NULL" in the preview.</li>
</ul>
<p>Thank you for your help,</p>
<p>Andreas</p>
<p><br /></p>
<p><br /></p>
</body></html>