>>Thank you for all suggestions
>>
>>
>>I was considering two options
>>
>>
>>1- Create a table for dates and a child table for appointments
>>(in this case appointments are records)
>>
>>2- Create a unique table where date and appointments are fields
>>
>>As the second option seems easy to me, I would like to know
>>if there are chances of having problems if I choose it
>
>With date, do you mean like, "5 Jan. 2010"? Why would that be in a separate table? I would just put it as a field in the appointments table.
>
>Or what is the information that might remain in a separate table?
Holidays.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]