I have been stuck on this for a while. Any suggestions would be really helpful.
I have two tables, one is the Facility Master Data where we maintain all the list of facilities that can be booked, it has Columns FaciltyID and FacilityName
The other one is Request table with column FaciltyID, EventStartDate and EventEndDate.
Request table contains all the bookings made for each facilities.
Now, If I create a new Request, I only want to show in the dropdown list those facilities from Facility master data that are available based on the selected dates of my current request.
How can I achieve this?