Can you remove the magnifying glass search option on a reference field on a record producer?

[mahudg2]

Can you remove the magnifying glass search option on a reference field on a record producer? There is information in the table list that we do not want users to know of. If not is there a way to submit a string from a record producer and have it submit properly as a reference value?

Thanks!

[rob_pastore]

Have you tried using a Lookup Select Box?   Basically it's a dropdown list that works the same as a reference field.

Not ideal for large table, but you can still type forward to get to the bottom.

[mahudg2]

I am using a large table. And the purpose of getting rid of the lookup select box is so the user is unable to see the contents of the table. I only want the user to be able to type their input into the field and not see any actual listing in the table it's referring to.

[rob_pastore]

Oh... I misunderstood.   I thought you didn't want the user seeing the other fields on the table (other than display name).   But you don't want them to see the other values in the table at all?

There would be no way to ensure that they typed it in correctly, it would be almost impossible to systematically link their string fields to a reference.

Unless it's using something like id number.   IF that's the case I would make it a text field and use a script to set the value.

[mahudg2]

I actually already have a script that is ensuring that these values are correct. I'll give an example.

I have 2 fields. One is username, and one is verification code.

The username is grabbed from a script inserting the g_user info.

Verification code is ensured to be correct since on the form each time a change is made a check is done to ensure that it is valid.

I want a user to enter their verification code and have it appear on the actual record without the user being able to look at the available verification codes since that is sensitive information.