Does retool create a new database connection for every open window?

Hi @David123 This second issue sounds like you might need to add a mapped value to the column. For both issues it may help to see some app and error screenshots

If the keys are changing dynamically, you'll either need to "Regenerate columns" from the table inspector:

or use dynamic column settings