Understand XML Node Mapping
- Last UpdatedJun 10, 2024
- 1 minute read
This section explains the importance of XML Nodes while designing a List or a Form. The XML node allows binding a SQL Database to a List and the List to be mapped to a Form.
The following are the XML Nodes with an example of a library database.
-
Database contains the table with columns such as, Id, Title, Author, Application.
-
In the List, the Author control is bound to the DB column Author.
-
In the Form, the Author Name control is mapped to the Author control in the list with the XML Node named Authorname.
A table column is mapped to a List control using the List control property 'Bound to DB Column' and the List control is mapped to Form control using 'Mapped XML Node'.
When you input data using a Form and the data is stored in the corresponding List, the List then updates the database table.
Note: When you design a List or Form, the Mapped XML Node allows mapping of a List to a Form. When you add a control for the first time, the XML Node is dynamically altered to reflect the Tag Name. Editing the Mapped XML Node at a later instance will affect the mapping between Forms, Lists, and Workflows.