Name pulling from a reference field

[Gregorrrry]

We have an employees table linked to a form. Employees table reads, Name, Email etc

In the form we are using:

Email = Useremail() (Ref to Employees table) - Email field

Name = (initial value) [Email].[name] - Text field

This works fine and the name appears, however we would like the 'Name' column to be a dropdown, not a text field. This dropdown would be of the names in the Employees table.

We have tried putting the Name field as a Reference but the initial value fails.

Is this possible to have the dropdown of names appear?

[diogolupcosta · Accepted solution]

Try to put in Auto Compute - Suggested Values - Employees_Table[Name]

[Gregorrrry]

Worked a treat. Thanks a lot.