Show one column related to the other

[dooblee]

Hello,

I have a MySQL table with set of ids and values. And i want to display the value from the set that has the specific id.

Can I do it? Is it possible? If yes, how?

Thanks!

[Alex K.]

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.

[dooblee]

Sure. I have a table in mySQL with the following two columns and the data:
ID | value
1 | value 1
2 | value 2
3 | value 3

When creating a form, I’d like to include only one value from the one row where ID=2. Is it possible to do somehow?

[Alex K.]

Hello,

You can use the filter for databand component, also you can modify the query with using the construction "where".

Thank you.