I have a form with three fields:
- Start Date (datetime)
- Finish Date (datetime)
- Resource (drop down)
I want to query a list to see which resources are not being used based on the dates picked by the user. and then show him/her only those resources.
Is it posible to do it whitout making the user close the form? And if not is it possible to reopen the form automatically once the calculation is done?
Which would be the best approach for this?