Help

Select only 1 record from selection field in form

Topic Labels: Formulas
310 1
cancel
Showing results for 
Search instead for 
Did you mean: 
user2100
7 - App Architect
7 - App Architect

in a form I have a record selection field. where employees are selected, I want only 1 name to be selected and not 2 or 3. But I don't know how to do it. have under:
Minimum and Maximum set the value at Maximum to 1. but doesn't work.

1 Reply 1

Hello,

There are 2 solutions for this.

- Solution 1

Create a table "Employee" and make your "employee" field in the table that you set the form on a linked field to table Employee and uncheck the option "Allow linking to mutiple records"

Pascal_Gallais_0-1726485202306.png

Solution 2

Define your "Employee" field as a single select field.

I advise to go for solution 1.

Regards,

Pascal