Cannot figure parent and child columns
Just bought Data Bridge, stumped by Dynamic Dropdowns.
I am trying to sort parent and child through one table, a list of soccer teams and their divisions) (table attached as screengrab).
I have sorted the recordset PARENT to list Divisions (field = TeamDiv) using
SELECT DISTINCT TeamDiv
FROM teams
ORDER BY TeamDiv ASC
and this brings me up a list of the six divisions
Therafter I am stumped as to how I bring up a child list of all the teams in that division.
I followed the tutorial as best I could and have a form on the page with PARENT and CHILD lists in a form.
Can you tell me
a/ what selections I should make to create the Dynamic Array
b/ what I should select from the options on the Populate From Array behaviour
(when I have tried various times the latter keeps saying that the form is "undefined" which seems wrong so I am assuming I have gone wrong before this point.....
Have attached the page if that helps....
basically I want the parent field to show the six divisions and, when one is clicked it shows the list of teams (field = TeamName) that correspond to that division....?
Thanks, as always, for your help guys