Question with name field

Hi,

I need to set up a notes name field to look up the address book for all choices. Easy enough, but I also need to rprevent any non-name text from being entered into the field. The way I did this before was through a display field and a button that pulls up the NAB in a picklist, but this method doesn’t inherit names that are already in the field into the picklist. Is there a way to have a names field on the form and keep the user from entering any text string into the field?

Thanks in advance.

Subject: “allow values not in list”

Wouldn’t you go to the Field Properties, second tab, and make sure to DEselect “allow values not in list”. Then, they can only use values in the list (lookup).

Or, if you don’t want them to be able to type at ALL:

Make the field computed.

Add a button with an @dblookup into an address list, then write the selected value(s) into the field, and refresh.

Subject: Re: allow values not in list

Thanks for your response, but the checkbox is already de-selected. Users are still able to type strings into the field.

And I already have a similar setup to the one you describe, but my problem is, when a value is already in the field and a user clicks the button to edit, it doesn’t pull over the pre-populated value into the NAB picklist. If there was a way to pull this value in from the names field, that would solve my problem.

Subject: oldname:@dblookup

You can create a lsit that has the old value plus the list of values from a lookup. Your formula would be something like:

oldvalue := fieldname;

newlist := (oldvalue : @dblookup(whever you get the list from));

newlist

Subject: check using dblookup

after entering the value check the value by using dblookup in the names.nsf, if available allow to save else valdiate it