Use of {field} in field Lookup Settings

Applications Forms
#1

I have a question: is it possible to use a {field} in a SQL statement in the Lookup Settings of another {field}.

Example:

A person can be member of an organisation. This organisation has titles (e.g. master, grandmaster}. This person can have a title (or not) so I want to make a select like below to make him chose. When i replace the {Organization_ID} with a fixed number it works.

SELECT ID, ShortDescription
FROM Title
WHERE ID IN (SELECT Title_ID FROM Organization_Has_Title Where Organization_ID = {Organization_ID})
ORDER BY ShortDescription

#2

It should be possible, but initially this statement will fail if the default is empty. Then the generated sql statment is invalid. So you might need to put the {field} between quotes.