> For the complete documentation index, see [llms.txt](https://help.auxalia.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.auxalia.com/plant-tools/plantexpresstools/how-to-use/update-selection-lists/setup/new-list-using-sqlite.md).

# New List using SQLite

In this example we use a SQLite database with the table "Media Color". This is actually from a Danish customer.

![](/files/OIK20ggmWqcqgF2LMybl)

We open the main dialog again.

![](/files/6PjNJtpKH2Mi8fzn33hF)

We see the configuration of the previous chapters. Make sure they are all disabled before continuing.

![](/files/rtqoK0dXmHNRvOv6UMfo)

This type we use "SQLite database files (\*.db;\*db3;\*.sqlite)" and select our sample file.

![](/files/VAW3bHhvHnnukyeMCUPT)

We adapt the path as in the previous chapters.

Databases can have tables and views (or queries). In our example there is just one table, so we select "Tables" and then select the table itself.

We then see all columns from our table.

![](/files/5twOLRSRuRYNB4BB5NsI)

We select "Service" and "Description" and the Category settings as before.

![](/files/ySnkVNy7ocDvETc1eB8a)

We see the new line.

![](/files/XW4PltjxoK8LIPoHPTbS)

We update the Selection List.

![](/files/mU79pPiKxO49rKSLno5v)

We get the result.

![](/files/1BcpmOt7eDdPNlCfq7Si)

When we check we see the content from our SQLite table.

![](/files/vNkVpmlUwuAfAvzQlGy7)