Hello,
I'm working with InfoPath 2010 in SP 2010. I have a Slots list in SP site with all the available slots for a meeting (column=TimeSlot) : 10:00, 11:00, 12:00, etc.. In my main Appointment list, i'm creating appointments with lookup of time from Slots.
I would like to show only those time slots that have not been occupied, i.e. on Form Load, set value of AvailableSlot (Appointment list) where TimeSlot (sec connection to Slots list) is not equal to AvailableSlot (secondary connection to Appoinment list). This is not working and it shows the drop down blank. Please let me know a better way to accomplish this.