What is the best way to allow users to add to a value list on the fly?

A line items table with a drop down list that uses values from an items table. If the user needs to add a new item to the value list, what is the best way to accomplish this?

Hi, Donkick!

When you setup field as drop-down list, you can check "Edit..." item to alow user editing value list.

What is the best way to allow users to add to a value list on the fly?

They have to have Edit and Layout level access. Not a great idea in IMHO.

A line items table with a drop down list that uses values from an items table. If the user needs to add a new item to the value list, what is the best way to accomplish this?

Check the online help in FileMaker for:

Setting up a field to display a pop-up menu, checkbox set, or other control

In Layout Mode, click on the field you wish to Field/Control Setup, and selec the Pop Menu, and you will see the option to include "Edit" in the list.

HTH

Lee

Yes you can give users the privilage to edit value list, as mentioned above. Limitations on which lists can be edited can be setup under /accounts & privilages/privilage sets/value list/custom

HTH

Tim

If its from line items, wouldn't you want only line items in the list? For this you might be better off using a value list directly from a field rather than a manual one.

Good point! A user should not be able to add a value to the value list which does not occur in the item table. How can you work with or sale what you don't have?

Best idea is as suggested by GENX, build value list from the field contents of the item table. This also guards against the user who cannot spell, has a habit of abreviating differently each time, or is just too lazy to search the list.

HTH

Tim