Good morning
I have 3 tables:

medicos
codigo nome
001 dr. joao
002 dr.eugenio

ausenciasmedico
medico data_ini data_fim
001 01/06/2008 05/06/2008
002 15/06/2008 15/06/2008
001 10/06/2008 10/06/2008

horariosmedico
medico entrada_manha saida_manha entrada_tarde saida_tarde
001 08:00 12:00 15:00 18:00
002 09:00 11:00 18:00 22:00

I have in the form 3 textbox:
one with the medico ex:(001)
onother with the date of the consult ex:(02/06/2008)
and another with the time of consult ex:(10:00)

I want two select:
one to detect that the medico ex:(001) is not disponible in the day 02/06/2008
And onother to detect that the medico ex:(002) is not disponible in the time 08:00

Thanks in advance.

Carlos Lima