Cascading Lists In Editor

th3t1ck

So I would like to use Dependent() to create a cascaded list in editor. I have two tables to query. The tables are Divisions and Area Offices. When you choose a division the area offices should populate the select field for area offices. The divisions and area offices have a location code. For example...

Division1
Location Code 100

Area Office1 - Location Code 110
Area Office1 - Location Code 120
Area Office1 - Location Code 130

Division2
Location Code 200

Area Office1 - Location Code 205
Area Office1 - Location Code 220
Area Office1 - Location Code 230

etc.

Can I have dependent query two different tables and if so what would that look like? Also how would I query in editor a value between 100 and 199 or 200 and 299 to get the area offices for that division?

th3t1ck

Hmmm, that should have read...

Division1
Location Code 100

Area Office1 - Location Code 110
Area Office2 - Location Code 120
Area Office3 - Location Code 130

Division2
Location Code 200

Area Office1 - Location Code 205
Area Office2 - Location Code 220
Area Office3 - Location Code 230