'related' input list

[Collin]

I'm making a scheduler in FileMaker Pro 5.5 where you can select a procedure (input list using the field procedure in the procedure database). There's a second field called steps in the database Procedure, in that field you write down the different steps needed for that procedure (every step on a separate line).

What I want to archive in the scheduler is the following:

The steps needed for the completion of the procedure will be listed in the steps field, the field is formatted as an input list with select boxes.

The input list in the field steps must be linked to the procedure, so that the list used are the steps for that specific procedure.

In other words: I need to perform a search for a specific procedure, the steps listed in the steps field then must then be used for an input list.

Also I need to make the script in such a way that if a value is selected in the input list that the scheduler database wont allow you to select another procedure.

I hope I wasn't to vague with describing my problem (I'm using a non-English FileMaker Pro version, so I need to translate every single FileMaker specific word to English).

[LiveOak]

Shouldn't be too hard. To display steps based upon a selected procedure, create a relationship between the main file and the procedure file based upon the "Procedure" field. The value list for the "Steps" field is then a display of the related "Steps" field based upon this relationship (it's an option in the value list creation dialog).

To prevent modification, paste a clear button over the "Procedure" field with the following script:

If( IsEmpty(Procedure))

Goto Field (Procedure)

Else

Goto Field ()

End If

This script will only allow you to "click into" the Procedure field if it is empty.

Your English is excellent and your description very clear.

-bd

[Pupiweb]

No need of a script

In your Scheduler.fp5 file make a relation to the Procedures.fp5 file, using the procedure name (or better a unique ProcedureID) ...

Use this relationship to build a relational value list, showing the procedure-related Steps field content, and attach this list to the Steps field: choosing a procedure will show only the steps related to the chosen procedure ...

Use the "Must be member of value list" field validation to make sure that only specific values are entered ...

[Collin]

Thanks for the advise.

I'll try your recommondations out tomorrow when I'm rested (had a long day today )