Forum Academy Marketplace Showcase Pricing Features

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

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.

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

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”

2 Likes

This topic was automatically closed after 70 days. New replies are no longer allowed.