Complex Scheduling Task

[andrea_delgiudi]

I have a schedule of medical conferences and we are always looking for faculty to sign up to teach them. How can I get the faculty to pick a date and then let the system close that date immediately for others. So we don’t accidentally over book?

[Kamille_Parks]

If your table is set up with a [Conference Sessions] table and a [Teacher Sign Up] table:

• Add a Link to Another Record field to the [Teacher Sign Up] table pointing at the [Conference Session]
• Add a view to [Conference Sessions] where {Teacher Sign Up} (the linked field) is empty
• In the form view for [Teacher Sign Up] set the {Conference Session} linked field’s options to be limited to the view set up in the step above.