1 Reply Latest reply on Sep 15, 2011 10:49 AM by Joy Garon

    "Interactive" SQL card list

    Jiri Maly

      Hallo everyone,

       

      I'm wondering if there is some way to populate a SQL card list with values depending on actual value of another card control like, e.g. text box.

       

      In other words:

       

      I have a folder (project) card with the Project number field and based on the value of this field I would like to populate an SQL List box (on the same card)

      Something like this:

       

      SELECT myFieldID FROM myTableName WHERE myProjectNumber = actual value given in the textbox

       

      Any ideas are higly appreciated.

       

      Thank you very much.

       

      Filip Kunc

      fkunc@tcf.cz