I hope the attachments get through, I scripted the table structures into two .sql files but as these are not valid extensions I have combined the two scripts into one...

Thanks for your prompt reply to my problem. I think I have not quite explained myself clearly enough.

The patient arrives in the OR at say 8am and leaves at 11am...