Creating a "customers" table where I'd like to have Employees from the employees table assigned to customers


I am building a table that will host a master customer field by a unique key. I'd like to have a field that is for employees that are assigned to that customer specifically.

Is there a way to pull a lookup field and select from employees on the Employee table?

Very new to Retool. Thanks in advanced!

You can have the AI generate it for you.... in other words ask the AI to create a customers table that contains a Primary Key and an employees table that contains the a foreign key by the same name as the primary key in the customers table.
This way multiple employees can be assigned the same customer primary key
select * from customers where (primary key name) = 'primary key value'

1 Like