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.