我想在表单布局中显示列表数据（来自数据库多个表） [英] I want to Show list data (come from database multiple tables) in form layout

问题描述

如何在编辑模式下在表单布局中显示动态数据。带有两个标题（超级标题和子标题）例如

how to show dynamic data in form layout in edit mode. with two headers(Super header and sub Header)e.g.

 Subject // subject is main header (Subject)
ex1 |ex2 // ex1 and ex2 sub header(no of exams of particular subject)
25  |26  // 25 and 26 is marks in edit mode.

ex1和ex2在运行时来自数据库。

所以有什么方法可以实现这种格式

ex1 and ex2 come from database at runtime.
so is there any way to achieve this format

推荐答案

你好Wasim，



您可以使用SQL查询将两个字段连成一个。

在您的示例中：ex1和ex2将变为 - > ex1 | ex2

Hi Wasim,

You can use the SQL query to concat both fields into one.
In your example: "ex1" and "ex2" will become --> "ex1 | ex2"

SELECT tbl.field1 + ' | ' + tbl.field2 AS result

应该到达那里。





干杯，

Edo

Should get you there.


Cheers,
Edo

这篇关于我想在表单布局中显示列表数据（来自数据库多个表）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！