I recently started using Retool and quickly encountered an issue. I have a Retool database table called "Orders," and one of its columns is named "auxiliary_device," which acts as a foreign key to another table I have called "Auxiliary_Device." This "Auxiliary_Device" table has a column named "Device" that contains information about various devices.
What I'd like to do is create a simple application where I can choose multiple auxiliary devices and save them as a new entry in my "Orders" table.
Hey @Matt_M! Can you share how that Orders table is set up? That error looks like it's complaining about a foreign key constraint. Not sure what data type that column is, but you should be able to set up an array type column if you create the table through SQL.
Create Table:
Insert data from multiselect, and display select * results in a table in the Retool app:
