Question & Answer > View Question

Datalist to show Fields from different Tables

Confluence User - 18 Sep, 2017

Hi, have a Principal Form (HR Expense Clai Form) that have many sub-forms embeded like Fomulario para Carga de Cotizaciones , i need show in a datalist or a grid that wil be used in task list later iwith a couple of fields that are in tables used by each sub-forms, is possible do it?

Datalist create for Principal form

Form that is used by this Datalist

Table used by Principal Form

Table used by sub-form

forms;datalists

2

Confluence User •

18 Sep, 2017 •

confluenceUser •

1 •

confluenceUser •

Although it is also possible to configure a Form Grid, in this case, it is advisable to use the Advanced Datalist Binder so you can adapt changes to data shown easier in the future.

Check out this link --> Advanced Form Data Binder

Since both the primary and sub-form uses the same table, i think it is possible to just select all your required columns in hr_expense_claim table.

Confluence User •

01 Oct, 2017 •

confluenceUser •

•

confluenceUser •

Hi Chris, tanks four your answer, it is an excelent feature, i would like more info about the SQL syntax , could you recommed any kind of tutorial?

i found that to reffer to tables i can use "app_fd_tablename" but need know how can i do join tables and show a couple of rows from these tables.

1

CSV | Excel | XML | PDF

Your answer

Print

Datalist to show Fields from different Tables

2

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

2.builder-style-cb855e07-0662-4b12-bcbd-c92e2ca6f4fb{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-e34dd814-3c54-455f-a709-393a45ed8e90{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

2

Your answer