How to join 2 different things in a data source from a dropdown list?

[danybergeron]

I would like to attach 2 objects in the data source of a drop-down list. How do I proceed?
Example I want to use client table and Reps table. I want to display first name, last name of the client with the first name and last name of the reps.

[john3]

Do you already have reps as part of the client table or not? I’m assuming that every client has 1 or more reps.

[romanmg]

Agreed with @john3. If you have a Rep field under the Client data type, you’ll be able to set the source of the dropdown to Clients only (it only takes 1 type) and then set the option label dynamically to be

“Current option (client)'s first/last name Current option’s rep’s first/last name”