I wish to create a report with 3 prompts and then set default values for the bottom 2 prompts based on the value selected in the first prompt.
Let us say these are the 3 prompts that I need to add to my report,
1. Version number
2. Version start date
3. Version end date
And say I also have a table named 'version' with columns - 'version_number', 'version_start_date' and 'version_end_date'. and that table has 3 rows with these values ((5.1, 01/01/2020, 06/30/2020), (5.2, 07/01/2020, 12/31/2020), (5.3, 01/01/2021, 06/30/2021))
I wish to populate the Version start date and Version end date prompts based on the value selected in Version number prompt. So, say if I select or enter 5.2 value in Version number prompt then I want Version start date and Version end date prompts to have default value of 07/01/2020 and 12/31/2020 respectively.
Any help with this is appreciated.