# Related entity multiline decimal

A table of lines from another table, maybe with a filter that relates them to this items DataID, and the option to input a decimal number next to each of them.

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: No
- Searchable: No

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">Field in edit mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

This field requires configuration of both parameters before it shows.

### <span class="mw-headline" id="bkmrk-config1-1">Config1</span>

The SQL-query executed, to list the items in the table.  
The first column should be \*DataID\* of the subitem, but it doesn't have to be. As long as \*a\* column includes this data.  
To relate the subtable to the current item, ad a \*where clause\* comparing to \*\[DataID\]\*, where \*\[DataID\]\* will be replaced be the current records DataID.

### <span class="mw-headline" id="bkmrk-config2-1">Config2</span>

The Label of the input column in the table.

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 232
- SQL datatype: INT(11)
- Class name: FieldMultiInputSubformListSQL