6 Replies Latest reply on Sep 2, 2014 9:34 AM by philmodjunk

    ExecuteSQL value list appears blank



      ExecuteSQL value list appears blank


      I've got a filtered value list that is being used to populate a foreign key. It's filtered thanks to a relationship between a table occurrence of the source table's Primary Key and an ExecuteSQL calculation in the related table (See attached image).

      This is what I have in the filtering calculation field:

      ExecuteSQL ( "
      SELECT \"Kp_GroupID\" FROM Group 
      WHERE NameActiveList = 'Yes'" ; "" ; ¶  )

      The problem: If I attempt to use the value list with a record that already has the value it works perfectly. However, if I attempt to use it with a new record the value list appear blank. It works fine if I enter a value (any value) into the pk field in the layout. 

      What is going wrong?