Hi,

I think the best setup is:
calender( calender_id, date)
reservation(reservation_id, room_id, client_id,calender_id)
This way you will have the max control over your database where for wach...

Hi,

I didn't get your point but it seems that there is some thing wrong in your relation between Rep and Employee table. Can you tell me what you need to do instead of what you are doing.

Hi,

What programming language are u using ??

Hi,
(First hope you have already found a solution)Usually this is the ultimate structure. But in your queeries you shall use outer oins to the loaction table espically if you suspect that the either...

Hi,
What are u using as an interface VB6, .net, access ... ? depending on that I may be able to provide you with the solution.

Hi,

We lately started adding all the allowed information to be view in 1 field for each user as a concatunated strings seperated by a special char like ";" or "/" then we check parts of it using...