Jun 22nd, 2011, 4:37 AM
See the problem is if I create a Team 1 select menu referencing the Team 1 field in a Club form it displays the Team 1 field from every Club record. What I want ideally is a chained select menu so you select a Club from menu 1, then menu 2 displays a series of Teams associated with that Club.
I know there are ways to reference a chained select menu to a database. I have seen a javascript that can do this but the lists are not dynamically created from a database but are coded into the script. I know it can be done in PHP, I see a field type called "Code/Markup" could this be used to call a PHP script?
I know there are ways to reference a chained select menu to a database. I have seen a javascript that can do this but the lists are not dynamically created from a database but are coded into the script. I know it can be done in PHP, I see a field type called "Code/Markup" could this be used to call a PHP script?