Announcement

Collapse
No announcement yet.

Use of {field} in field Lookup Settings

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Use of {field} in field Lookup Settings

    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.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment

    Working...
    X