> For the complete documentation index, see [llms.txt](https://docs.oneweb.tech/oneweb/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.oneweb.tech/oneweb/reference/app-designer-reference/entity/create-new-entity/module/one-to-many.md).

# One to Many

**(1-Many)** module displays and manages data fields for multiple records in the database. It shows data in tabular form. The One to Many (1-Many) module is based on grid and card layout design and allow users to handle large num**1-1 module** displays and manages data for one record in the database. It is based on row and column layout where you can simply add rows and columns as per your required design. Simply drag the 1-1 Module icon to the desired Tab to create a 1-1 Module.

The 1-1 Module configuration provides a list of property settings (1-5) as shown below:

![](https://2015371994-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMpDjHWFRUtZ5nJcSfVXd%2Fuploads%2FxLDpRlt5B5FisOxJGEXM%2Fimage.png?alt=media\&token=1ee1ced0-3e30-4f06-a853-18e7e5673cb4)

![](https://2015371994-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMpDjHWFRUtZ5nJcSfVXd%2Fuploads%2FTe7E7zVJ8RwXZxZJiQfx%2Fimage.png?alt=media\&token=68702403-8a26-4da3-917f-79726452c61d)- This icon is used to open "**Module Configuration**" property window. 1-1 Module configuration property window provides a list of settings which can be helpful in specific needs or special purposes. All 1-1 Module configuration settings along with their usage are listed in table below:

<table data-header-hidden><thead><tr><th></th><th width="196"></th><th></th><th></th></tr></thead><tbody><tr><td><strong>Module Item</strong></td><td><strong>Default value</strong></td><td><strong>Mandatory</strong></td><td><strong>Description</strong></td></tr><tr><td>Module ID</td><td>N/A</td><td>Y</td><td>Module ID is the unique ID and it is generated by system automatically.</td></tr><tr><td>Module Name</td><td>1-1 Module</td><td>Y</td><td>The appropriate name for a module.</td></tr><tr><td>Table Name</td><td>N/A</td><td>Y</td><td>The table associated with that module.</td></tr><tr><td>Template Code</td><td>Responsive2016</td><td>Y</td><td>Default to same as template Code used for an Entity.</td></tr><tr><td>Theme Code</td><td>Responsive2016</td><td>Y</td><td>Default to same as theme Code used for an Entity.</td></tr><tr><td>Show List Layout</td><td>GRID</td><td>Y</td><td>Show Grid Layout / Card Layout for the search result.</td></tr><tr><td>Module Key</td><td>N/A</td><td>Y</td><td>This is set the field to be used as the Key to the Module.</td></tr><tr><td>Prefix</td><td>N/A</td><td></td><td>This is used to configure prefix that will be added to the beginning of the Key when automatically generated.</td></tr><tr><td>Postfix</td><td>N/A</td><td></td><td>This is used to configure suffix that will be added to the end of the Key when automatically generated.</td></tr><tr><td>KeyLen</td><td>N/A</td><td>Y</td><td>Key Len is to set size of key.</td></tr><tr><td>Sequence</td><td>N/A</td><td>Y</td><td>Database Sequence to be used for key generation.</td></tr><tr><td>SQL Show List</td><td>N/A</td><td></td><td>This is used to set the manual SQL Command used to query data to display in Module in Tabular Format (Only used in 1- Many Modules).</td></tr><tr><td>SQL Work Queue</td><td>N/A</td><td></td><td>This is used to set the manual SQL Command to query data to display in Search Results.</td></tr><tr><td>SQL Select Row</td><td>N/A</td><td></td><td>This is used to write the manual SQL Command to be used to query data in 1-1 Module.</td></tr><tr><td>SQL Duplicate Function</td><td>N/A</td><td></td><td><strong>-</strong></td></tr><tr><td>View Mode Flag</td><td>N</td><td></td><td>Make your module in View/Read Mode only.</td></tr><tr><td>Paging Flag</td><td>N</td><td></td><td>Enables paging for search result.</td></tr><tr><td>Ordering Flag</td><td>N</td><td></td><td>Enables sorting in the headed of data grid.</td></tr><tr><td>Multiple table Flag</td><td>N</td><td></td><td><strong>-</strong></td></tr></tbody></table>

![](https://2015371994-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMpDjHWFRUtZ5nJcSfVXd%2Fuploads%2FMlJLrW0a6qnyTJcmi1CU%2Fimage.png?alt=media\&token=00107281-09cf-4280-86be-717b18ebdf6e)- This Icon is used to drag and drop modules to rows and columns in Multi Column Tab Form layout.

![](https://2015371994-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMpDjHWFRUtZ5nJcSfVXd%2Fuploads%2F9mArmIElpE6eT8Et7KQx%2Fimage.png?alt=media\&token=05fa458c-d206-4485-abf9-00defe723a59)- This Icon is used to set the Column Layout which determines how many columns the module has. It has 3 options to choose from - 1 Column, 2 Column and 3 Column. User can select any options based on the layout requirement. User must click on 'Accept' button after choosing a desired option.

![](https://2015371994-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMpDjHWFRUtZ5nJcSfVXd%2Fuploads%2FY1GmiKSsvXxne5TTbutK%2Fimage.png?alt=media\&token=ead3ec1c-c17c-4d17-87ba-9e37775edd35)

![](https://2015371994-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMpDjHWFRUtZ5nJcSfVXd%2Fuploads%2F5gPOXO4YBwQ4PcWvsYFy%2Fimage.png?alt=media\&token=35d58163-183d-4a2b-9b9b-64dfb247cd4f)- This Icon is used to delete a Module from your Smart Form Layout.

![](https://2015371994-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMpDjHWFRUtZ5nJcSfVXd%2Fuploads%2FbLE0IMLJ2sEEAW2FDQKS%2Fimage.png?alt=media\&token=cbd95653-c27e-4cf3-b0da-4a96d80df502) - This Icon is used to add column or row inside your Module Layout. First Icon add Column in your module and second icon is used to add row. User can add multiple rows and columns inside module Layout on basis of smart form requirements.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.oneweb.tech/oneweb/reference/app-designer-reference/entity/create-new-entity/module/one-to-many.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.