"Interactive" SQL card list

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

SolidworksSolidworks Pdm enterprise Pdm