AnsweredAssumed Answered

ExecuteSQL value list appears blank

Question asked by JosephMauriello on Aug 31, 2014
Latest reply on Sep 2, 2014 by philmodjunk

Title

ExecuteSQL value list appears blank

Post

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?

Manage_Database_for_%E2%80%9CTesting_Concepts%E2%80%9D.png

Outcomes