plcamp

Thanks LiveOak, I will try this today... Now am I correct that with this scheme, the value list will not "update itself" when someone adds a new items. What I have is a list of vendors of services that's already pretty long. Every time someone adds a new project, they may ... a) Pick vendors from the list that already exists : Pick some of the vendors from the existing list, and also add new ones c) Add only new vendors to the list. ...so I think that what you suggest will work for the first option but not for the second and third? I have been using the 'other' option for this value list so far. Anyway I'll experiment with what you suggest - thanks for taking the time to outline it to me.

OK, I have a growing value list that derives from the current entries in a field. The problem...is that the list has grown so large that the pop-up menu is larger than the available area on the monitor. I know I need some sort of heirarchical pop-up menu - preferable which has "a-f" ; "g-n" etc so that users can quickly get to the entry they need. Can anyone reference me to a URL that explains how to set up such a heirarchical pop-up menu? I have FMP 5.

I'm new here, need some help with something... I've got FMP 5, and am part way through design of 5 interlinked databases to control discovery of certain electronic parts from a flat-file extract of a large Oracle database. One of the things I want to do is allow a pop-up menu selection with a value list "from a field" - but the number of unique entries int hat field is so large that the pop-up menu extends off the visible screen area - result is that you can't see and you can't scroll over to items in the last half of the list. Ideally, a heirarchical value list with first selections "a-f", "g-n" etc would be used to get a smally choice list subservient to the first choice. Any of you folks know how to do that?