This tutorial describes how to make a set of tiered list menus in 3 steps. When one menu is changed, the options in the other menu change. The tutorial assumes that you have some experience with Custom Web Publishing, HTML and JavaScript.
Step 1. -- Creat the Filemaker Database (or just download it)
Create 2 Filemaker tables in a new database. In this example we'll use 'country' and 'state'. This relationship view shows the fields I created and how they are related:
The ID fields should be autoentry serial number fields.
2 layouts should have been automatically created, 'state' and 'country'. Go into the country layout and create 2 countries (or records) with the names: 'USA' and 'Canada'.
Go into the 'state' layout, go into layout mode, and double-click the 'IDcountry' field. Under 'Display as' choose 'Pop-up menu'. Under 'Display values from' choose 'Define value lists'. Create a new value list and call it 'countries'. Choose the 'Use values from field:' option. Specify the table 'country' and the field 'IDcountry'. Check the 'Also display values from' check box and then specify the table 'country' and the field 'name'.
Click OK 4 times (until you're back in the layout mode). Go into the Browse mode and enter several states or provinces and choose the correspnding country from the pop-up list.
Step 2. -- Open the Database
Set the necessary permissions for XSLT web publishing. If your not sure what they should be you can download the example file. Go into your Filemaker Server Admin and open the database for web publishing.
Step 3. -- Publish to the web
You will need 4 files: download menus.xsl, errorreply.xsl and utilities.xsl and place them all in the xslt-templates-files directory on you server. Then download javascript.js and place it anywhere you can host javascript files. In menus.xsl you will need to change this line to point to it:
<script type="text/javascript" src="http://your-domain.com/scripts/javascript.js"></script>
Now open menu.xsl by going to the following url: http://your-domain.com/fmi/xsl/menu/menus.xsl
