Question & Answer > View Question

How to combine 2 table into one form?

Confluence User - 07 Jun, 2024

Hi,

Can anyone help me combine 2 table to one form? Now my all form is only using one table which many of the column type is longtext, it auto assign longtext

datalists;forms;userviews;server

1

Confluence User •

07 Jun, 2024 •

confluenceUser •

•

confluenceUser •

hi, You can use the Form data store option :Form Data Store to combine two tables.
the easiest is by using Database Wizard Form Data Store Where it allows users to visually configure the database connection and perform queries without coding.

Another way is you can use Load data store on section level .
where you can specify which table would you like to load from on the specific section.
example :
Section A load from Table A
Section B Load from Table B

And include the form element according to the column configuration for each table .

Hope it helps!