Populate Single Select with Lookup

1369 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello dear Community

As the title suggests, I am trying to populate a Single Select field type with the results of a Lookup. Is this possible?

I looks like I’m not allowed to paste links here so I cannot share my base, so I will describe what I want to do below.

I have a table of persons, and a table of emails. A person can have more than one email. So far so good.

I then have a third table called service that lists all the persons that belong to some digital service (think JIRA). Obviously you can only have one email address per account on such a service. So I want a field that presents me with a dropdown of emails associated with the person in that record.

First prize would be for me to be able to update the service table with a new record, lookup the correct person (add if it does not exist) and then if I add an email that is not already associated with that person just update person.

Second prize would be for me to update person first with the email, and then go to service and add the new record into service looking up the correct email.

Is this not possible?

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

Hey Daniel,
Did you manage to populate the Single Select (dropdown) with data from another table using a Lookup? I can’t get my head around it. If you could point me in the right direction it would be much appreciated.