Trivial Value List Problem

[jeffEngland]

I have a bunch of fields that are Drop-Down Lists and works great. However I want the user only to be able to select values in the drop-down list.

I know that If I use a Pop Up menu this will force the user to select a value in the list. However I do not like the design of the field Itself. I would prefer to have the same layout of a Drop-Down List (borders and arrow to the right). I tried to leave the Pop Up menu with no stroke and draw everything manually on top of it, but when I click the field, everything I drew is sent behind it and I can no longer see it. I've been playing around with this for a while and have not had any luck. Does anyone have any suggestions?

thx

Jeff England

[ThatOneGuy]

Hi Jeff:

What about setting field validation to be a member of a value list? Would that work for what you need?

[jeffEngland]

I think it would work however the function I would have to use, or atleast I think I would use would be,

ValueListItems ( "Reservation Book" ; Duration )

which returns all the values in the list seperated by carriage returns. Im not a 100% sure of how I would go about it.

The part thats a little fuzzy is how would I loop through those values to verify each one?

I could be out to lunch and it prolly is alot easier lol.

Jeff England

[ThatOneGuy]

It could be approached that way, but I was talking about the "standard issue" Field Validation options. Going into Define Database, we can double-click on a field's definition to pull up Options. Clicking over to the Validation panel, it is the third option under the Require subcategory. Activate Member of value list, then select/define the appropriate value list.

FileMaker's native validation schemes can sometimes be aggravating, but at least it's an option for your challenge.

[jeffEngland]

I knew what you were suggesting must of been easier than what I was trying and it was and its working now, im going to play with it for a bit now. Atleast I have another option now.

Thanks for your help

Jeff England