I am new to FM10 - I have been converting databases for our clients, but I am not very fluent in script writing.
I have a database with one table. I want to create a main page that gives users an option to select a season. After clicking on a season, a page would show all the program numbers listed by the selected season air dates. The table is called Table, the two fields that are needed to show are: ShowNumber and AirDate.
The main page will show the following:
Season Three (2008-2009)
Season Two (2007-2008)
Season One (2006-2007)
I can't write the script to successfully pull out the Programs/Shows using data range calculation. Any help would be greatly appreciated.