I have an existing reservation/booking system in place n my dev Sharepoint environment ( SP 2010 ).
It consists of a Resouces list and a reservations list.
I want to desing a form in Infopath that will provide a reservation / booking form that looks up information from the resources list and displays them in a drop down.
Once I fill out the req start date and end date, when i click submit, the form should only submit of that resource is not already booked in for that time slot.
Whats the best way to do this ?
Thanks and regards,
Swetha