HI, am a newbie. Have been using Access. Have been trying to figure
out a way to include items into the drop down list for items that are
currently not in the drop down list during data entry. Eg Have a
field Restaurant with drop down list items A,B,C. Now need to include
Rest D. Use type D into the Restaurant Field. Field validate and then
dialog box, "Item not in list. Do you want to add" Yes, No. Click Yes.
Restaurant D is added to existing list, and cursor move to next
record.

Can anybody help?

Thanks.

In article
<a1f5fab2-8bdd-4dd6-b282-762df2216b1f (AT) f31g2000pri (DOT) googlegroups.com>,
vincent vincent <vkvkcy (AT) gmail (DOT) com> wrote:

There's no in-built function like that in FileMaker Pro.

You can set a Field formatted as a pop-up menu / list to include an
"Other" option which allows users to enter another value and that new
value is of course available in calculations, etc., but that user-entered
value will not appear in the pop-up menu / list for use in other records.

The normal method would be to use a separate Table to store the values for
the pop-up menu and create have Scripts, etc. to let users add values to
that Table so they do then show up in the pop-up menu / list.

Helpful Harry )

In article <slrnitjp6o.e58.t-usenet (AT) ID-685 (DOT) user.individual.de>,
Martin ɱrautmann <t-usenet (AT) gmx (DOT) net> wrote:

You can set up either of two basic kinds of value list: Static and
Dynamic.

A static value list has preset values that you define. Then when you
format a field in a layout, you can set it up to allow other values to
be entered, and also can set it up to allow the user to edit the list.
Of course, in order to edit the list, the user privileges have to allow
editing of that value list.

A dynamic value list takes values from a field in a table. There are
variations available for defining a dynamic value list, as you will
discover in FileMaker Help. Anyway, if the values in the table change,
the value list will change accordingly.

I would stay away from field validation that requires only value list
items, unless you really need that for a good reason in a specific case.
It doesn't matter for a dynamic value list, as such a list by its
definition uses only values that are in the specified field of the
specifies table. For a static value list that you want the user to be
able to edit, the field validation seems unnecessary.

--
Bill Collins

vincent vincent <vkvkcy (AT) gmail (DOT) com> wrote:

You can use Pop-Up Menu with "Edit..." option, if it's right for you.


--
Per rispondere, togliere -NOSPAM- dall'indirizzo.