I am trying to Substitute Value Lists in real time?
I have three pulldown lists in a row
-One for Month
-One for the Day of the Month
-One for the year
I want the "Day of the Month" pulldown list to switch to an appropriate value list that only has the correct number of days for the selected
month.
I setup a secondary file with a field named "Days" and I created 31 indexed records with the data 1 thru 31 in the records. I set up a "value
list" named "day list" in the secondary file that uses the data from the "Days" field. I told my primary file to us the "value list" named
"day list" from my secondary file and bingo ... it worked. Now I need to figure out how to make it limit the number of days based on the
month that was selected. I also added a repeating field in my secondary file called "months". It lists all the months with that records day
available. For instance the file with the value of "1" for "day" has all twelve months in the repeating month field. The file with the value of
"31" for "day" has only the seven months that have 31 days. I created this field because I was going to do something with the find
feature, but I haven't figured out how to make it work. I have a "month selected" field that has the user selected month (in number 01
thru 12). Any ideas?
also, does anyone know of a template or plug in available for download that has the feature I am trying to create?
-Thank You