Hi

I am trying to set drop-down list with value list but that list is not
always the same.

I got one filed drop-down list as well which you choosing what are you
need and then you press button to run script. And that scrip need to
change value list in my secound drop-down list.

I have been trying many ways to do that but still without expect
results.
In my thinking something like that should work but is not. I gues is
have to be connect somehow with my value list which is set for that
field when I created that field.

Or it is possible change value list by script. I mean if I define a
few value list it is possible to change setting of the field by the
script.

if[Schedules DB::Where="One"]
Set Field [Schedules DB::Where=SEA; GetValue(One DB:Name;1)]
End if

Thx for any help

In article <1171936032.113693.38220 (AT) k78g2000cwa (DOT) googlegroups.com>,
faq (AT) faqsyd (DOT) com wrote:

You can't change a static Value List that's been typed into the Define
Value List window from a script, but unless you're doing something a
little peculiar you don't need to have a script to changes values.

You could mess around with multiple value lists and multiple pop-up
list fields all placed in a pile on the Layout with a script working
out which one the user wants, but the usual way is to use a separate
Table to hold the possible Value List options and define a Relationship
to retrieve the appropriate one.

Create a new Table and type in Records for each possible combination.
eg.
Record 1 Make = "Porsche" Model = "911 Turbo"
Record 2 Make = "Porsche" Model = "Boxster"
Record 3 Make = "Jaguar" Model = "XKR"
Record 4 Make = "Jaguar" Model = "XJ6"
Record 5 Make = "Ford" Model = "Mondeo"
Record 6 Make = "Ford" Model = "Escort"
Record 7 Make = "Ford" Model = "GT"

Back in the original Table create a new Relationship that links the two
Tables by Make.
ie.
rel_CarMake match OriginalTable to MakeTable
when UserMake = MakeTable::Make

Now define a Value List that obtains it's values from the Model field
via this Relationship. You'll also need another Value List, a normal
one, that contains all the Makes typed into it.

Then you can put two fields on the Layout - UserMake using the normal
Value List and UserModel using the value list with the Relationship.

Now when someone chooses an option from the UserMake field, the
UserModel field's value list will contain just the appropriate matching
options.
ie. User chooses "Jaguar" in UserMake,
the value list for UserModel contains just "XKR" and "XJ6".



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

[Version not specified. Answer assumes at least FileMaker 7]

See if my Dynamic Value List demo is anything you can use:

http://www.virtualvermont.com/FMP/

As for selecting something then clicking a button to run a script, see also the EventSecript demo for how to make that happen automatically.

Matt

On 02/19/2007 20:47:12 faq (AT) faqsyd (DOT) com wrote:

Thank you Helpful Harry...your heaps of help is happily happening in
my healthy haven.

Creatively,
Carpeflora
"Seize the Beauty"

Matt... Just pulled down the value list based on global field...will
fix something that I've been fighting with. Mucho Gracie,
Creatlvely,
Carpeflora
"Sieze the Beauty"