Hide Dropdown list

[carobernachea]

I have a log of user access and egress.
When they register to enter, if their ID has already been entered, it will be in the drop-down list to select, and it will auto-complete the user’s data.
If it does not exist, it will go to NEW and will be created by completing the form from scratch.

My question is, is there a way to hide those values ​​and that is more like an “autocomplete” or that detects the ID of the USERS table and from there, brings the data.

Since it is unsafe for other people’s IDs to be shown, since anyone could complete registrations under another ID that is not theirs.

I leave images so you can understand

Thanks in advance,
Greetings!

[lynchk21]

It won’t be an auto-complete, but if you set the column to a text type, and use IN([_This],USERS[ID])=TRUE This will prevent new users from “selecting” new, so then you would need to create an action button to a new form, or a different way to navigate to a new form for new users

[carobernachea]

It worked! But it leaves the “true” eternally written, and I have to delete it to enter the value…

[lynchk21]

Put the IN([_This],USERS[ID])=TRUE in the valid_if field rather than the initial value

[carobernachea]

oh!!! thanks thanks thanks