How do I get a TV to call a value from another TV?
I’ve searched for ages and can’t seem to get this to work...
I have a template with 3 TV’s: FilmTitleTV; FilmDateTV; and FilmTimeTV.
FilmTitleTV is drop down list with a @SELECT call to the database which retrieves, you guessed it, Film Titles.
I need the FilmDateTV to call the database using `@SELECT date FROM pptable WHERE title=’FilmTitleTV’`
Then FilmTimeTV will call database with `@SELECT time FROM pptable WHERE title=’FilmTitleTV’ and date=’FilmDateTV’`
So the user would choose a film title from the drop down list. Based on their choice, the second drop down list would be populated with dates for that film. Based on that choice, the third drop down list would list all the film times for that date.
I’m not sure how to use javascript to update the 2nd and 3rd TV’s. Any help would be appreciated!!
