Hi Community members ,

I need use a custom HTML control to show various fields from diferents tables, i did try to get thems from a datalist that use a Datasource query  option but it don´t work . In other hand also try to get the info directly from the tables and does not work either.

Anybody know if it is possible?

It is the example of the Datalist, Query and HTML code:

SQL Query on CONS_COTIZA_CLI  datalist:  

" SELECT a.id, a.c_username,a.c_total_prop,a.c_quotation_number,a.dateCreated,a.c_customer,a.c_due_date, b.c_accountName FROM app_fd_hr_expense_claim a INNER JOIN app_fd_mcrm_account b
ON a.c_customer=b.id AND a.c_status='Submitted'  "

HTML  CODE USED TO GET THE FIELDS:

<td>
#form.hr_expense_claim.due_date#                        !! This Piece work fine !!
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="layout2">
<div class="col first billShip">
<h3>
ATENCIÓN:
</h3>
<div>
<strong>#form.hr_expense_claim.customer_contact#</strong>
</div>
<div>
#form.CONS_COTIZA_CLI.accountName#    !! This Piece don´t work !!
</div>
<div>
<div>
#form.mcrm_accoun.email#                          !! This Piece don´t work !!
</div>
<div>