Hello and thank you for looking at my problem.
I am trying to create dynamic or cascading drop down lists in Livecycle Designer ES2 v.9. I need a total of three drop down lists. The third DDL would provide three or four possible dates depending on the selections made in DDL1 and DDL2. The list items in DDL1 and DDL2 do not change. DDL1 is to identify the first letter of the person's last name (which is already stated in a previous DDL linked to an Access Database). DDL2 is the event being requested. The options in DDL1 and DDL2 do not change so they can be manually entered (unless someone has a better way to identify the first letter of the last name listed in the DDL at the top of the form). But the list of possible dates in DDL3 is always changing. Several computers would access the changing dates in DDL3 so if the dates could be updated in one place, this would be optimal.
I have been assuming that the best way to solve this problem is by linking DDL3 to an access database. (If there is an easier way, please let me know.) But I cannot get this to work. I have read, and re-read and re-re-read Stephen Cameron's blog postings, but these examples are now five years and several versions old, and I cannot seem to make it work. I cannot figure out whether to use the exit event, the change event or the pre-open event, and which DDL the code should be placed. I have benefited from this forum more than you know, so I do not ask this question lightly. I have spent several days (weeks?) trying to solve this, but I'm at wits-end, so it is time to ask.
Any help would be greatly appreciated.