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

App Building
1

Hello,

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!

2

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