How to get value from another table

dire · Post by **dire** » Fri Oct 07, 2016 2:16 pm

Table A has value form Table B (tableB.id) and I need value from Table B( tableB.code).
I want to use custom function with ew_ExecuteScalar (Select TableB.code FROM TableB WHERE ??) in global code and then call this function from custom attributes field.

Please for some good example, because Iâ€™m starting to learn.

thx :)

motfs · Post by **motfs** » Thu Oct 13, 2016 12:24 pm

You can put JavaScript function in Custom Attribute only. But your code is server side. Elaborate in detail what you try to do.

dire · Post by **dire** » Thu Oct 13, 2016 1:35 pm

I have Table Customer with fields (name, surname, address, post, state, etc). Fields post, state are FK from table sif_post and sif_state.
I would like to have link on field address (for googl emaps).
I manage Prefix (url for googl emaps), HREF value is address, I need post_code from sif_post and state_code from sif_state

motfs · Post by **motfs** » Sat Oct 15, 2016 1:25 pm

You can create Custom Field to get the value (test your SQL expression first) and use these fields to create full address. Read Custom Fields in help file for more details.

dire · Post by **dire** » Sat Oct 15, 2016 1:29 pm