Script to Generate Pop-Up Sub-Categories?

[jfdowshen]

Trying to create "simple?" form to allow user to select (via popup menu in the first field) a master list of technologies. When that first field is populated – it would automatically show list or popup menu of available sub-technologies (related only to the specific technology first chosen) in the second field. This would occur onward for three or four sub-level fields.

Is this done via an "IF" script? Have used FM for years, but only for easy contact list information. This concept is totally new to me. Please be basic with your reply.

Thanks for your expertise!

Joel

[jwren]

Hi Joel

You can do this by creating a conditional value list.

You will need to create a table that has 2 fields. The master list of technologies and the list of sub-technologies. Lets call the table Technologies

Create a relationship between the Technologies table and the form table using the master technology as the match field.

Now create a value list (sub-technologies)with the "Use values from field" checked and specify the relationship you created between the Technologies table and the Form table. When selecting the match field it must be the sub-technologies field.

Specify "Include only related values" and from the "current table".

Format the sub-tchnologies field as a popup list and display the values from (sub-technologies) value list.

For all subsequent sub-levels follow the same procedure.

Hope I have not left anything out here.

Jen.