Jump to content

Add items to a drop down list on the fly


Donkick
 Share

This topic is 5646 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 4 weeks later...

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5646 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.