Auto selection of Value Lists according to 1st Sel

[corey]

I have a single file set up with 5 Fields.

Each field has a unique value list.

I want to set up a script or Calculation so that When i make the desired selection in the 1st Field, then according to the selection, the other 4 Fields are AUTO Entered.

I am using FMP 4.0v1.

Any help would be very much appreciated

Corey....

Jsa and Wms.zip

[Pupiweb]

Depending on the data you might use a lookup (probably better) or an autoenter calc

Lookup:

Create a second file Data.fp5

Create 5 fields, similarly to your main file

Create a record for each possible choice of the list of field 1, and enter the values you want to be autoentered in fields 2 to 5

In your main file relate field1 to field1 of Data.fp5

Set field 2 to 5 to lookup data from Data.fp5 using this relationship

[cjaeger]

or use a simple auto-enter CASE calc:

field2=Case(field1="optionA","f2optionA","optionB","f2optionB", ........)

[corey]

Can some one apply thie above suggestions to the att file to help me out here??

Regards

Corey....

[corey]

The dishes are DONE.

Thnx Pupiweb

Follwed them and Hey Presto.

Corey...